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

Line 152: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

148:
149: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
150: --
151: IF l_debug_on IS NULL THEN
152: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
153: END IF;
154: --
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.push(l_module_name);

Line 156: WSH_DEBUG_SV.push(l_module_name);

152: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
153: END IF;
154: --
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.push(l_module_name);
157: WSH_DEBUG_SV.log(l_module_name,'p_group_by_header', p_group_by_header);
158: WSH_DEBUG_SV.log(l_module_name,'p_check_fte_compatibility', p_check_fte_compatibility);
159: END IF;
160:

Line 157: WSH_DEBUG_SV.log(l_module_name,'p_group_by_header', p_group_by_header);

153: END IF;
154: --
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.push(l_module_name);
157: WSH_DEBUG_SV.log(l_module_name,'p_group_by_header', p_group_by_header);
158: WSH_DEBUG_SV.log(l_module_name,'p_check_fte_compatibility', p_check_fte_compatibility);
159: END IF;
160:
161:

Line 158: WSH_DEBUG_SV.log(l_module_name,'p_check_fte_compatibility', p_check_fte_compatibility);

154: --
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.push(l_module_name);
157: WSH_DEBUG_SV.log(l_module_name,'p_group_by_header', p_group_by_header);
158: WSH_DEBUG_SV.log(l_module_name,'p_check_fte_compatibility', p_check_fte_compatibility);
159: END IF;
160:
161:
162:

Line 179: WSH_DEBUG_SV.log(l_module_name,' p_line_rows('||i||').entity_id', p_line_rows(i).entity_id);

175:
176: IF l_debug_on THEN
177: i := p_line_rows.FIRST;
178: WHILE i is not NULL LOOP
179: WSH_DEBUG_SV.log(l_module_name,' p_line_rows('||i||').entity_id', p_line_rows(i).entity_id);
180: i := p_line_rows.next(i);
181: END LOOP;
182: END IF;
183:

Line 205: WSH_DEBUG_SV.logmsg(l_module_name,' Get delivery detail: '||p_line_rows(i).entity_id );

201: IF p_line_rows(l_current_line).group_id = p_line_rows(i).group_id THEN
202: l_cc_in_ids(l_cc_in_ids.count+1) := p_line_rows(i).entity_id;
203:
204: IF l_debug_on THEN
205: WSH_DEBUG_SV.logmsg(l_module_name,' Get delivery detail: '||p_line_rows(i).entity_id );
206: END IF;
207:
208: END IF;
209: i := p_line_rows.next(i);

Line 221: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main');

217: IF wsh_util_core.fte_is_installed = 'Y'
218: AND p_check_fte_compatibility = FND_API.G_TRUE
219: AND l_cc_in_ids.count > 1 THEN
220: IF l_debug_on THEN
221: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main');
222: END IF;
223: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(
224: p_api_version_number => 1.0,
225: p_init_msg_list => FND_API.G_FALSE,

Line 259: WSH_DEBUG_SV.logmsg(l_module_name,'l_cc_line_groups('|| i ||').entity_line_id: '||l_cc_line_groups(i).entity_line_id);

255: -- build l_cc_group_ids to hold the sub-group IDs
256: l_cc_groupExists := FALSE ;
257:
258: IF l_debug_on THEN
259: WSH_DEBUG_SV.logmsg(l_module_name,'l_cc_line_groups('|| i ||').entity_line_id: '||l_cc_line_groups(i).entity_line_id);
260: WSH_DEBUG_SV.logmsg(l_module_name,'l_cc_line_groups('|| i ||').line_group_id: '||l_cc_line_groups(i).line_group_id);
261: END IF;
262:
263: IF l_cc_group_ids.COUNT > 0 THEN

Line 260: WSH_DEBUG_SV.logmsg(l_module_name,'l_cc_line_groups('|| i ||').line_group_id: '||l_cc_line_groups(i).line_group_id);

256: l_cc_groupExists := FALSE ;
257:
258: IF l_debug_on THEN
259: WSH_DEBUG_SV.logmsg(l_module_name,'l_cc_line_groups('|| i ||').entity_line_id: '||l_cc_line_groups(i).entity_line_id);
260: WSH_DEBUG_SV.logmsg(l_module_name,'l_cc_line_groups('|| i ||').line_group_id: '||l_cc_line_groups(i).line_group_id);
261: END IF;
262:
263: IF l_cc_group_ids.COUNT > 0 THEN
264: j := l_cc_group_ids.FIRST;

Line 276: WSH_DEBUG_SV.logmsg(l_module_name,'Add Sub-group '||l_cc_line_groups(i).line_group_id||' to table l_cc_group_ids' );

272: END IF;
273: IF (NOT(l_cc_groupExists)) THEN
274: l_cc_group_ids(l_cc_group_ids.count+1) := l_cc_line_groups(i).line_group_id;
275: IF l_debug_on THEN
276: WSH_DEBUG_SV.logmsg(l_module_name,'Add Sub-group '||l_cc_line_groups(i).line_group_id||' to table l_cc_group_ids' );
277: END IF;
278: END IF;
279:
280: -- update p_line_rows with new sub_group ids

Line 288: WSH_DEBUG_SV.logmsg(l_module_name,'change group id of p_line_rows('||k||').entity_id '|| p_line_rows(k).entity_id||' to ' ||l_cc_line_groups(i).line_group_id);

284: -- correct the group_id with constraint group_id
285: p_line_rows(k).group_id := l_cc_line_groups(i).line_group_id;
286:
287: IF l_debug_on THEN
288: WSH_DEBUG_SV.logmsg(l_module_name,'change group id of p_line_rows('||k||').entity_id '|| p_line_rows(k).entity_id||' to ' ||l_cc_line_groups(i).line_group_id);
289: END IF;
290:
291: exit;
292: END IF;

Line 346: WSH_DEBUG_SV.log(l_module_name,' Fetched candidate delivery '|| to_char(l_delivery_id));

342: END IF;
343: -- store column value in local variables
344:
345: IF l_debug_on THEN
346: WSH_DEBUG_SV.log(l_module_name,' Fetched candidate delivery '|| to_char(l_delivery_id));
347: WSH_DEBUG_SV.log(l_module_name,' l_ignore_for_planning'||l_ignore_for_planning); -- OTM R12
348: END IF;
349:
350:

Line 347: WSH_DEBUG_SV.log(l_module_name,' l_ignore_for_planning'||l_ignore_for_planning); -- OTM R12

343: -- store column value in local variables
344:
345: IF l_debug_on THEN
346: WSH_DEBUG_SV.log(l_module_name,' Fetched candidate delivery '|| to_char(l_delivery_id));
347: WSH_DEBUG_SV.log(l_module_name,' l_ignore_for_planning'||l_ignore_for_planning); -- OTM R12
348: END IF;
349:
350:
351: -- l_delivery_done indicastes if it needs to exit out of the sub-group loop

Line 369: WSH_DEBUG_SV.log(l_module_name,' l_cc_group_ids('||i||') ', l_cc_group_ids(i));

365:
366: IF l_debug_on THEN
367: i := l_cc_group_ids.FIRST;
368: WHILE i is not NULL LOOP
369: WSH_DEBUG_SV.log(l_module_name,' l_cc_group_ids('||i||') ', l_cc_group_ids(i));
370: i := l_cc_group_ids.next(i);
371: END LOOP;
372: END IF;
373:

Line 427: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action '|| l_return_status);

423: x_defaults => l_defaults,
424: x_action_out_rec => l_action_out_rec);
425:
426: IF l_debug_on THEN
427: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action '|| l_return_status);
428: END IF;
429:
430: -- OTM R12 : update delivery
431: l_tms_update := 'N';

Line 453: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');

449:
450: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
451: x_return_status := l_otm_return_status;
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
454: WSH_DEBUG_SV.pop(l_module_name);
455: END IF;
456: RETURN;
457: END IF;

Line 454: WSH_DEBUG_SV.pop(l_module_name);

450: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
451: x_return_status := l_otm_return_status;
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
454: WSH_DEBUG_SV.pop(l_module_name);
455: END IF;
456: RETURN;
457: END IF;
458:

Line 475: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');

471:
472: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
473: x_return_status := l_otm_return_status;
474: IF l_debug_on THEN
475: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
476: WSH_DEBUG_SV.pop(l_module_name);
477: END IF;
478: RETURN;
479: END IF;

Line 476: WSH_DEBUG_SV.pop(l_module_name);

472: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
473: x_return_status := l_otm_return_status;
474: IF l_debug_on THEN
475: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
476: WSH_DEBUG_SV.pop(l_module_name);
477: END IF;
478: RETURN;
479: END IF;
480:

Line 528: WSH_DEBUG_SV.log(l_module_name, 'l_action_out_rec.result_id_tab('||i||')', l_action_out_rec.result_id_tab(i));

524:
525: IF l_debug_on THEN
526: i := l_action_out_rec.result_id_tab.FIRST;
527: WHILE i is not NULL LOOP
528: WSH_DEBUG_SV.log(l_module_name, 'l_action_out_rec.result_id_tab('||i||')', l_action_out_rec.result_id_tab(i));
529: i := l_action_out_rec.result_id_tab.next(i);
530: END LOOP;
531: END IF;
532:

Line 568: WSH_DEBUG_SV.log(l_module_name,' log_exception failed ');

564:
565:
566: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR , WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.log(l_module_name,' log_exception failed ');
569: END IF;
570: raise log_exception_err;
571: END IF;
572:

Line 583: WSH_DEBUG_SV.logmsg(l_module_name,'Added delivery_detail_id '||p_line_rows(j).entity_id||' to x_assigned_rows' );

579: x_assigned_rows(x_assigned_rows.count+1).delivery_detail_id := p_line_rows(j).entity_id;
580: x_assigned_rows(x_assigned_rows.count).delivery_id := l_delivery_id;
581:
582: IF l_debug_on THEN
583: WSH_DEBUG_SV.logmsg(l_module_name,'Added delivery_detail_id '||p_line_rows(j).entity_id||' to x_assigned_rows' );
584: END IF;
585: l_date_scheduled := least(NVL(l_date_scheduled,p_line_rows(j).date_scheduled), p_line_rows(j).date_scheduled);
586: l_date_requested := least(NVL(l_date_requested,p_line_rows(j).date_requested), p_line_rows(j).date_requested);
587: p_line_rows.delete(j);

Line 598: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );

594: END LOOP;
595:
596: -- update appended delivery
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
599: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
600: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );

Line 599: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );

595:
596: -- update appended delivery
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
599: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
600: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);

Line 600: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );

596: -- update appended delivery
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
599: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
600: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
604: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);

Line 601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );

597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
599: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
600: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
604: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
605: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );

Line 602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );

598: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
599: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
600: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
604: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
605: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
606: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);

Line 603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);

599: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
600: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
604: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
605: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
606: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
607: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);

Line 604: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);

600: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
604: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
605: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
606: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
607: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
608:

Line 605: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );

601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
604: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
605: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
606: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
607: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
608:
609: -- OTM R12 : update delivery

Line 606: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);

602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
604: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
605: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
606: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
607: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
608:
609: -- OTM R12 : update delivery
610: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);

Line 607: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);

603: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
604: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
605: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
606: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
607: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
608:
609: -- OTM R12 : update delivery
610: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
611: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);

Line 610: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);

606: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
607: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
608:
609: -- OTM R12 : update delivery
610: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
611: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);
612: IF (l_tms_update = 'Y') THEN
613: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));
614: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);

Line 611: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);

607: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
608:
609: -- OTM R12 : update delivery
610: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
611: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);
612: IF (l_tms_update = 'Y') THEN
613: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));
614: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);
615: END IF;

Line 613: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));

609: -- OTM R12 : update delivery
610: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
611: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);
612: IF (l_tms_update = 'Y') THEN
613: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));
614: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);
615: END IF;
616: -- End of OTM R12 : update delivery
617: END IF;

Line 614: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);

610: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
611: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);
612: IF (l_tms_update = 'Y') THEN
613: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));
614: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);
615: END IF;
616: -- End of OTM R12 : update delivery
617: END IF;
618:

Line 650: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');

646: x_return_status => l_otm_return_status);
647: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
648: x_return_status := l_otm_return_status;
649: IF l_debug_on THEN
650: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
651: WSH_DEBUG_SV.pop(l_module_name);
652: END IF;
653: RETURN;
654: END IF;

Line 651: WSH_DEBUG_SV.pop(l_module_name);

647: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
648: x_return_status := l_otm_return_status;
649: IF l_debug_on THEN
650: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
651: WSH_DEBUG_SV.pop(l_module_name);
652: END IF;
653: RETURN;
654: END IF;
655: END IF;

Line 677: WSH_DEBUG_SV.log(l_module_name, 'l_action_out_rec.result_id_tab('||i||')', l_action_out_rec.result_id_tab(i));

673: i := l_action_out_rec.result_id_tab.FIRST;
674: WHILE i is not NULL LOOP
675:
676: IF l_debug_on THEN
677: WSH_DEBUG_SV.log(l_module_name, 'l_action_out_rec.result_id_tab('||i||')', l_action_out_rec.result_id_tab(i));
678: END IF;
679:
680: IF l_attr_tab(1).batch_id is NULL THEN
681:

Line 708: WSH_DEBUG_SV.log(l_module_name,' log_exception failed ');

704: p_delivery_detail_id => l_action_out_rec.result_id_tab(i));
705:
706: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR , WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
707: IF l_debug_on THEN
708: WSH_DEBUG_SV.log(l_module_name,' log_exception failed ');
709: END IF;
710: raise log_exception_err;
711: END IF;
712:

Line 723: WSH_DEBUG_SV.logmsg(l_module_name,'Added delivery_detail_id '||p_line_rows(j).entity_id||' to x_assigned_rows' );

719: x_assigned_rows(x_assigned_rows.count+1).delivery_detail_id := p_line_rows(j).entity_id;
720: x_assigned_rows(x_assigned_rows.count).delivery_id := l_delivery_id;
721:
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.logmsg(l_module_name,'Added delivery_detail_id '||p_line_rows(j).entity_id||' to x_assigned_rows' );
724: END IF;
725: -- get the date_scheduled and date_requrested
726: l_date_scheduled := least(NVL(l_date_scheduled,p_line_rows(j).date_scheduled), p_line_rows(j).date_scheduled);
727: l_date_requested := least(NVL(l_date_requested,p_line_rows(j).date_requested), p_line_rows(j).date_requested);

Line 749: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );

745: i := l_action_out_rec.result_id_tab.next(i);
746: END LOOP;
747:
748: IF l_debug_on THEN
749: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
750: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
751: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );

Line 750: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );

746: END LOOP;
747:
748: IF l_debug_on THEN
749: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
750: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
751: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);

Line 751: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );

747:
748: IF l_debug_on THEN
749: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
750: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
751: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
755: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);

Line 752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );

748: IF l_debug_on THEN
749: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
750: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
751: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
755: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
756: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );

Line 753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );

749: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
750: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
751: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
755: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
756: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
757: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);

Line 754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);

750: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
751: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
755: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
756: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
757: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
758: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);

Line 755: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);

751: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
755: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
756: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
757: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
758: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
759: -- OTM R12 : update delivery

Line 756: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );

752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
755: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
756: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
757: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
758: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
759: -- OTM R12 : update delivery
760: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);

Line 757: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);

753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );
754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
755: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
756: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
757: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
758: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
759: -- OTM R12 : update delivery
760: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
761: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);

Line 758: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);

754: WSH_DEBUG_SV.log(l_module_name, 'date_scheduled', l_date_scheduled);
755: WSH_DEBUG_SV.log(l_module_name, 'date_requested', l_date_requested);
756: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
757: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
758: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
759: -- OTM R12 : update delivery
760: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
761: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);
762: IF (l_tms_update = 'Y') THEN

Line 760: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);

756: WSH_DEBUG_SV.log(l_module_name, 'service_level', l_attr_tab(1).service_level );
757: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
758: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
759: -- OTM R12 : update delivery
760: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
761: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);
762: IF (l_tms_update = 'Y') THEN
763: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));
764: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);

Line 761: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);

757: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', l_attr_tab(1).mode_of_transport);
758: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', l_attr_tab(1).source_header_id);
759: -- OTM R12 : update delivery
760: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
761: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);
762: IF (l_tms_update = 'Y') THEN
763: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));
764: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);
765: END IF;

Line 763: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));

759: -- OTM R12 : update delivery
760: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
761: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);
762: IF (l_tms_update = 'Y') THEN
763: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));
764: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);
765: END IF;
766: -- End of OTM R12 : update delivery
767: END IF;

Line 764: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);

760: WSH_DEBUG_SV.log(l_module_name, 'l_gc3_is_installed', l_gc3_is_installed);
761: WSH_DEBUG_SV.log(l_module_name, 'l_tms_update', l_tms_update);
762: IF (l_tms_update = 'Y') THEN
763: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag_tab', l_new_interface_flag_tab(1));
764: WSH_DEBUG_SV.log(l_module_name, 'l_tms_version_number', l_tms_version_number);
765: END IF;
766: -- End of OTM R12 : update delivery
767: END IF;
768:

Line 800: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');

796: x_return_status => l_otm_return_status);
797: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
798: x_return_status := l_otm_return_status;
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
801: WSH_DEBUG_SV.pop(l_module_name);
802: END IF;
803: RETURN;
804: END IF;

Line 801: WSH_DEBUG_SV.pop(l_module_name);

797: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
798: x_return_status := l_otm_return_status;
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
801: WSH_DEBUG_SV.pop(l_module_name);
802: END IF;
803: RETURN;
804: END IF;
805: END IF;

Line 839: WSH_DEBUG_SV.logmsg(l_module_name,'Added delivery_detail_id '||p_line_rows(i).entity_id||' to x_unassigned_rows' );

835: WHILE i is not NULL LOOP
836: IF p_line_rows(i).group_id = l_group_id THEN
837: x_unassigned_rows(x_unassigned_rows.count+1):= p_line_rows(i).entity_id;
838: IF l_debug_on THEN
839: WSH_DEBUG_SV.logmsg(l_module_name,'Added delivery_detail_id '||p_line_rows(i).entity_id||' to x_unassigned_rows' );
840: END IF;
841: p_line_rows.delete(i);
842: END IF;
843: i := p_line_rows.next(i);

Line 885: WSH_DEBUG_SV.log(l_module_name,'p_line_rows count', p_line_rows.count);

881: WHILE i is not NULL LOOP
882:
883: -- this table has gaps
884: IF l_debug_on THEN
885: WSH_DEBUG_SV.log(l_module_name,'p_line_rows count', p_line_rows.count);
886: END IF;
887: j := p_line_rows.FIRST;
888: WHILE j is not null LOOP
889:

Line 893: WSH_DEBUG_SV.logmsg(l_module_name,'Added delivery_detail_id '||p_line_rows(j).entity_id||' to x_unassigned_rows' );

889:
890: IF p_line_rows(j).group_id = l_cc_group_ids(i) THEN
891: x_unassigned_rows(x_unassigned_rows.count+1):= p_line_rows(j).entity_id;
892: IF l_debug_on THEN
893: WSH_DEBUG_SV.logmsg(l_module_name,'Added delivery_detail_id '||p_line_rows(j).entity_id||' to x_unassigned_rows' );
894: END IF;
895: p_line_rows.delete(j);
896: END IF;
897:

Line 912: WSH_DEBUG_SV.log(l_module_name,'x_unassigned_rows('||i||')' , x_unassigned_rows(i));

908:
909: IF l_debug_on THEN
910: i := x_unassigned_rows.FIRST;
911: WHILE i is not NULL LOOP
912: WSH_DEBUG_SV.log(l_module_name,'x_unassigned_rows('||i||')' , x_unassigned_rows(i));
913: i := x_unassigned_rows.next(i);
914: END LOOP;
915: END IF;
916:

Line 923: WSH_DEBUG_SV.pop(l_module_name, 'Return Status: '||x_return_status);

919: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
920: END IF;
921:
922: IF l_debug_on THEN
923: WSH_DEBUG_SV.pop(l_module_name, 'Return Status: '||x_return_status);
924: END IF;
925:
926:
927:

Line 940: WSH_DEBUG_SV.pop(l_module_name, 'Log_exception returns error ');

936:
937: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
938: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
939: IF l_debug_on THEN
940: WSH_DEBUG_SV.pop(l_module_name, 'Log_exception returns error ');
941: END IF;
942:
943:
944: WHEN others THEN

Line 953: WSH_DEBUG_SV.pop(l_module_name);

949: END IF;
950: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');
951: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
952: IF l_debug_on THEN
953: WSH_DEBUG_SV.pop(l_module_name);
954: END IF;
955:
956:
957: END Auto_Assign_Deliveries;

Line 1085: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1081: SAVEPOINT START_OF_APPEND_DELIVERIES;
1082: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1083: --
1084: IF l_debug_on IS NULL THEN
1085: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1086: END IF;
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.push(l_module_name);
1089: WSH_DEBUG_SV.log(l_module_name, 'p_append_flag', p_append_flag);

Line 1088: WSH_DEBUG_SV.push(l_module_name);

1084: IF l_debug_on IS NULL THEN
1085: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1086: END IF;
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.push(l_module_name);
1089: WSH_DEBUG_SV.log(l_module_name, 'p_append_flag', p_append_flag);
1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1091: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);

Line 1089: WSH_DEBUG_SV.log(l_module_name, 'p_append_flag', p_append_flag);

1085: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1086: END IF;
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.push(l_module_name);
1089: WSH_DEBUG_SV.log(l_module_name, 'p_append_flag', p_append_flag);
1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1091: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);
1093: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);

Line 1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);

1086: END IF;
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.push(l_module_name);
1089: WSH_DEBUG_SV.log(l_module_name, 'p_append_flag', p_append_flag);
1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1091: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);
1093: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);
1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);

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

1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.push(l_module_name);
1089: WSH_DEBUG_SV.log(l_module_name, 'p_append_flag', p_append_flag);
1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1091: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);
1093: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);
1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);
1095:

Line 1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);

1088: WSH_DEBUG_SV.push(l_module_name);
1089: WSH_DEBUG_SV.log(l_module_name, 'p_append_flag', p_append_flag);
1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1091: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);
1093: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);
1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);
1095:
1096: END IF;

Line 1093: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);

1089: WSH_DEBUG_SV.log(l_module_name, 'p_append_flag', p_append_flag);
1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1091: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);
1093: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);
1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);
1095:
1096: END IF;
1097:

Line 1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);

1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1091: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);
1093: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);
1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);
1095:
1096: END IF;
1097:
1098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1108: WSH_DEBUG_SV.log(l_module_name,'p_delivery_detail_tbl('||l_index||'): ',p_delivery_detail_tbl(l_index));

1104: -- need to check append_limit in shipping parameters
1105: l_index := p_delivery_detail_tbl.FIRST;
1106: WHILE l_index is NOT NULL LOOP
1107: IF l_debug_on THEN
1108: WSH_DEBUG_SV.log(l_module_name,'p_delivery_detail_tbl('||l_index||'): ',p_delivery_detail_tbl(l_index));
1109: END IF;
1110:
1111:
1112: OPEN get_line_details_check(p_delivery_detail_tbl(l_index));

Line 1169: WSH_DEBUG_SV.log(l_module_name,' l_detail_info('||i||').entity_id', l_detail_info(i).entity_id);

1165:
1166: IF l_debug_on THEN
1167: i := l_detail_info.FIRST;
1168: WHILE i is not NULL LOOP
1169: WSH_DEBUG_SV.log(l_module_name,' l_detail_info('||i||').entity_id', l_detail_info(i).entity_id);
1170: i := l_detail_info.next(i);
1171: END LOOP;
1172: END IF;
1173:

Line 1180: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Group_Delivery_Details');

1176: IF l_detail_info.count > 0 THEN
1177: l_unassigned_rows.delete;
1178:
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Group_Delivery_Details');
1181: END IF;
1182:
1183: l_action_rec.action := 'CREATE_GROUPS';
1184: l_action_rec.group_by_header_flag := p_group_by_header;

Line 1196: WSH_DEBUG_SV.logmsg(l_module_name,' after calling Find_Matching_Groups');

1192: x_out_rec => l_out_rec,
1193: x_return_status => l_return_status);
1194:
1195: IF l_debug_on THEN
1196: WSH_DEBUG_SV.logmsg(l_module_name,' after calling Find_Matching_Groups');
1197: i := l_detail_info.FIRST;
1198: WHILE i is not NULL LOOP
1199: WSH_DEBUG_SV.log(l_module_name,' l_detail_info('||i||').entity_id', l_detail_info(i).entity_id);
1200: i := l_detail_info.next(i);

Line 1199: WSH_DEBUG_SV.log(l_module_name,' l_detail_info('||i||').entity_id', l_detail_info(i).entity_id);

1195: IF l_debug_on THEN
1196: WSH_DEBUG_SV.logmsg(l_module_name,' after calling Find_Matching_Groups');
1197: i := l_detail_info.FIRST;
1198: WHILE i is not NULL LOOP
1199: WSH_DEBUG_SV.log(l_module_name,' l_detail_info('||i||').entity_id', l_detail_info(i).entity_id);
1200: i := l_detail_info.next(i);
1201: END LOOP;
1202:
1203: END IF;

Line 1213: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from wsh_delivery_autocreate.Find_Matching_Groups: '|| l_return_status );

1209: raise Group_Delivery_Details_ERR;
1210: END IF;
1211:
1212: IF l_debug_on THEN
1213: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from wsh_delivery_autocreate.Find_Matching_Groups: '|| l_return_status );
1214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Auto_Assign_Deliveries');
1215: END IF;
1216:
1217: Auto_Assign_Deliveries(

Line 1214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Auto_Assign_Deliveries');

1210: END IF;
1211:
1212: IF l_debug_on THEN
1213: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from wsh_delivery_autocreate.Find_Matching_Groups: '|| l_return_status );
1214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Auto_Assign_Deliveries');
1215: END IF;
1216:
1217: Auto_Assign_Deliveries(
1218: p_line_rows => l_detail_info,

Line 1227: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from Auto_Assign_Deliveries: '|| l_return_status );

1223: x_appended_del_tbl => x_appended_del_tbl,
1224: x_return_status => l_return_status);
1225:
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from Auto_Assign_Deliveries: '|| l_return_status );
1228: END IF;
1229:
1230: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1231: l_warning_num := l_warning_num + 1;

Line 1240: WSH_DEBUG_SV.log(l_module_name,'x_unappended_det_tbl.count', x_unappended_det_tbl.count);

1236: l_index := l_unassigned_rows.next(l_index);
1237: END LOOP;
1238: END IF;
1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.log(l_module_name,'x_unappended_det_tbl.count', x_unappended_det_tbl.count);
1241: END IF;
1242: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1243: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1244: raise Auto_Assign_Deliveries_ERR;

Line 1259: wsh_debug_sv.pop(l_module_name);

1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1256: END IF;
1257:
1258: IF l_debug_on THEN
1259: wsh_debug_sv.pop(l_module_name);
1260: END IF;
1261:
1262: EXCEPTION
1263:

Line 1271: wsh_debug_sv.logmsg(l_module_name, 'Group_Delivery_Details failed');

1267: FND_MESSAGE.SET_NAME('WSH', 'WSH_GRP_DETAILS_ERR');
1268: wsh_util_core.add_message(x_return_status, l_module_name);
1269:
1270: IF l_debug_on THEN
1271: wsh_debug_sv.logmsg(l_module_name, 'Group_Delivery_Details failed');
1272: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Group_Delivery_Details_ERR');
1273: END IF;
1274:
1275: WHEN Auto_Assign_Deliveries_ERR THEN

Line 1272: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Group_Delivery_Details_ERR');

1268: wsh_util_core.add_message(x_return_status, l_module_name);
1269:
1270: IF l_debug_on THEN
1271: wsh_debug_sv.logmsg(l_module_name, 'Group_Delivery_Details failed');
1272: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Group_Delivery_Details_ERR');
1273: END IF;
1274:
1275: WHEN Auto_Assign_Deliveries_ERR THEN
1276: ROLLBACK TO START_OF_APPEND_DELIVERIES;

Line 1282: wsh_debug_sv.logmsg(l_module_name, 'Auto_Assign_Deliveries failed');

1278: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTO_ASSIGN_ERR');
1279: wsh_util_core.add_message(x_return_status, l_module_name);
1280:
1281: IF l_debug_on THEN
1282: wsh_debug_sv.logmsg(l_module_name, 'Auto_Assign_Deliveries failed');
1283: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Auto_Assign_Deliveries_ERR');
1284: END IF;
1285:
1286: WHEN Others THEN

Line 1283: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Auto_Assign_Deliveries_ERR');

1279: wsh_util_core.add_message(x_return_status, l_module_name);
1280:
1281: IF l_debug_on THEN
1282: wsh_debug_sv.logmsg(l_module_name, 'Auto_Assign_Deliveries failed');
1283: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Auto_Assign_Deliveries_ERR');
1284: END IF;
1285:
1286: WHEN Others THEN
1287: ROLLBACK TO START_OF_APPEND_DELIVERIES;

Line 1296: wsh_debug_sv.log(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM);

1292:
1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1294: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
1295: IF l_debug_on THEN
1296: wsh_debug_sv.log(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM);
1297: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
1298: END IF;
1299:
1300: END Append_to_Deliveries;

Line 1297: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');

1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1294: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
1295: IF l_debug_on THEN
1296: wsh_debug_sv.log(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM);
1297: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
1298: END IF;
1299:
1300: END Append_to_Deliveries;
1301: