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

Line 125: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

121: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
122: --
123: IF l_debug_on IS NULL
124: THEN
125: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
126: END IF;
127: --
128: wsh_debug_sv.start_debug (l_trns_history_rec.entity_number);
129:

Line 128: wsh_debug_sv.start_debug (l_trns_history_rec.entity_number);

124: THEN
125: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
126: END IF;
127: --
128: wsh_debug_sv.start_debug (l_trns_history_rec.entity_number);
129:
130: /*
131: wsh_debug_sv.start_other_app_debug(
132: p_application => 'OE',

Line 131: wsh_debug_sv.start_other_app_debug(

127: --
128: wsh_debug_sv.start_debug (l_trns_history_rec.entity_number);
129:
130: /*
131: wsh_debug_sv.start_other_app_debug(
132: p_application => 'OE',
133: x_debug_directory => oe_debug_dir,
134: x_debug_file => oe_debug_file,
135: x_return_status => l_return_status);

Line 137: wsh_debug_file := WSH_DEBUG_SV.G_FILE;

133: x_debug_directory => oe_debug_dir,
134: x_debug_file => oe_debug_file,
135: x_return_status => l_return_status);
136:
137: wsh_debug_file := WSH_DEBUG_SV.G_FILE;
138: wsh_debug_dir := WSH_DEBUG_SV.G_DIR;
139: */
140: IF l_debug_on THEN
141: wsh_debug_sv.push (l_module_name, 'PROCESS_INBOUND');

Line 138: wsh_debug_dir := WSH_DEBUG_SV.G_DIR;

134: x_debug_file => oe_debug_file,
135: x_return_status => l_return_status);
136:
137: wsh_debug_file := WSH_DEBUG_SV.G_FILE;
138: wsh_debug_dir := WSH_DEBUG_SV.G_DIR;
139: */
140: IF l_debug_on THEN
141: wsh_debug_sv.push (l_module_name, 'PROCESS_INBOUND');
142: wsh_debug_sv.log (l_module_name,'DOCUMENT NUMBER',l_trns_history_rec.document_number);

Line 141: wsh_debug_sv.push (l_module_name, 'PROCESS_INBOUND');

137: wsh_debug_file := WSH_DEBUG_SV.G_FILE;
138: wsh_debug_dir := WSH_DEBUG_SV.G_DIR;
139: */
140: IF l_debug_on THEN
141: wsh_debug_sv.push (l_module_name, 'PROCESS_INBOUND');
142: wsh_debug_sv.log (l_module_name,'DOCUMENT NUMBER',l_trns_history_rec.document_number);
143: wsh_debug_sv.log (l_module_name,'DOC TYPE',l_trns_history_rec.document_type);
144: wsh_debug_sv.log (l_module_name,'ACTION TYPE',l_trns_history_rec.action_type);
145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);

Line 142: wsh_debug_sv.log (l_module_name,'DOCUMENT NUMBER',l_trns_history_rec.document_number);

138: wsh_debug_dir := WSH_DEBUG_SV.G_DIR;
139: */
140: IF l_debug_on THEN
141: wsh_debug_sv.push (l_module_name, 'PROCESS_INBOUND');
142: wsh_debug_sv.log (l_module_name,'DOCUMENT NUMBER',l_trns_history_rec.document_number);
143: wsh_debug_sv.log (l_module_name,'DOC TYPE',l_trns_history_rec.document_type);
144: wsh_debug_sv.log (l_module_name,'ACTION TYPE',l_trns_history_rec.action_type);
145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);
146: wsh_debug_sv.log (l_module_name,'ENTITY TYPE',l_trns_history_rec.entity_type);

Line 143: wsh_debug_sv.log (l_module_name,'DOC TYPE',l_trns_history_rec.document_type);

139: */
140: IF l_debug_on THEN
141: wsh_debug_sv.push (l_module_name, 'PROCESS_INBOUND');
142: wsh_debug_sv.log (l_module_name,'DOCUMENT NUMBER',l_trns_history_rec.document_number);
143: wsh_debug_sv.log (l_module_name,'DOC TYPE',l_trns_history_rec.document_type);
144: wsh_debug_sv.log (l_module_name,'ACTION TYPE',l_trns_history_rec.action_type);
145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);
146: wsh_debug_sv.log (l_module_name,'ENTITY TYPE',l_trns_history_rec.entity_type);
147: wsh_debug_sv.log (l_module_name,'DIRECTION',l_trns_history_rec.document_direction);

Line 144: wsh_debug_sv.log (l_module_name,'ACTION TYPE',l_trns_history_rec.action_type);

140: IF l_debug_on THEN
141: wsh_debug_sv.push (l_module_name, 'PROCESS_INBOUND');
142: wsh_debug_sv.log (l_module_name,'DOCUMENT NUMBER',l_trns_history_rec.document_number);
143: wsh_debug_sv.log (l_module_name,'DOC TYPE',l_trns_history_rec.document_type);
144: wsh_debug_sv.log (l_module_name,'ACTION TYPE',l_trns_history_rec.action_type);
145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);
146: wsh_debug_sv.log (l_module_name,'ENTITY TYPE',l_trns_history_rec.entity_type);
147: wsh_debug_sv.log (l_module_name,'DIRECTION',l_trns_history_rec.document_direction);
148: wsh_debug_sv.log (l_module_name,'TRADING PARTNER',l_trns_history_rec.trading_partner_id);

Line 145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);

141: wsh_debug_sv.push (l_module_name, 'PROCESS_INBOUND');
142: wsh_debug_sv.log (l_module_name,'DOCUMENT NUMBER',l_trns_history_rec.document_number);
143: wsh_debug_sv.log (l_module_name,'DOC TYPE',l_trns_history_rec.document_type);
144: wsh_debug_sv.log (l_module_name,'ACTION TYPE',l_trns_history_rec.action_type);
145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);
146: wsh_debug_sv.log (l_module_name,'ENTITY TYPE',l_trns_history_rec.entity_type);
147: wsh_debug_sv.log (l_module_name,'DIRECTION',l_trns_history_rec.document_direction);
148: wsh_debug_sv.log (l_module_name,'TRADING PARTNER',l_trns_history_rec.trading_partner_id);
149: wsh_debug_sv.log (l_module_name,'ORIG DOC NUMBER',l_trns_history_rec.orig_document_number);

Line 146: wsh_debug_sv.log (l_module_name,'ENTITY TYPE',l_trns_history_rec.entity_type);

142: wsh_debug_sv.log (l_module_name,'DOCUMENT NUMBER',l_trns_history_rec.document_number);
143: wsh_debug_sv.log (l_module_name,'DOC TYPE',l_trns_history_rec.document_type);
144: wsh_debug_sv.log (l_module_name,'ACTION TYPE',l_trns_history_rec.action_type);
145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);
146: wsh_debug_sv.log (l_module_name,'ENTITY TYPE',l_trns_history_rec.entity_type);
147: wsh_debug_sv.log (l_module_name,'DIRECTION',l_trns_history_rec.document_direction);
148: wsh_debug_sv.log (l_module_name,'TRADING PARTNER',l_trns_history_rec.trading_partner_id);
149: wsh_debug_sv.log (l_module_name,'ORIG DOC NUMBER',l_trns_history_rec.orig_document_number);
150: END IF;

Line 147: wsh_debug_sv.log (l_module_name,'DIRECTION',l_trns_history_rec.document_direction);

143: wsh_debug_sv.log (l_module_name,'DOC TYPE',l_trns_history_rec.document_type);
144: wsh_debug_sv.log (l_module_name,'ACTION TYPE',l_trns_history_rec.action_type);
145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);
146: wsh_debug_sv.log (l_module_name,'ENTITY TYPE',l_trns_history_rec.entity_type);
147: wsh_debug_sv.log (l_module_name,'DIRECTION',l_trns_history_rec.document_direction);
148: wsh_debug_sv.log (l_module_name,'TRADING PARTNER',l_trns_history_rec.trading_partner_id);
149: wsh_debug_sv.log (l_module_name,'ORIG DOC NUMBER',l_trns_history_rec.orig_document_number);
150: END IF;
151:

Line 148: wsh_debug_sv.log (l_module_name,'TRADING PARTNER',l_trns_history_rec.trading_partner_id);

144: wsh_debug_sv.log (l_module_name,'ACTION TYPE',l_trns_history_rec.action_type);
145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);
146: wsh_debug_sv.log (l_module_name,'ENTITY TYPE',l_trns_history_rec.entity_type);
147: wsh_debug_sv.log (l_module_name,'DIRECTION',l_trns_history_rec.document_direction);
148: wsh_debug_sv.log (l_module_name,'TRADING PARTNER',l_trns_history_rec.trading_partner_id);
149: wsh_debug_sv.log (l_module_name,'ORIG DOC NUMBER',l_trns_history_rec.orig_document_number);
150: END IF;
151:
152: -- bug 2393138

Line 149: wsh_debug_sv.log (l_module_name,'ORIG DOC NUMBER',l_trns_history_rec.orig_document_number);

145: wsh_debug_sv.log (l_module_name,'ENTITY NUMBER',l_trns_history_rec.entity_number);
146: wsh_debug_sv.log (l_module_name,'ENTITY TYPE',l_trns_history_rec.entity_type);
147: wsh_debug_sv.log (l_module_name,'DIRECTION',l_trns_history_rec.document_direction);
148: wsh_debug_sv.log (l_module_name,'TRADING PARTNER',l_trns_history_rec.trading_partner_id);
149: wsh_debug_sv.log (l_module_name,'ORIG DOC NUMBER',l_trns_history_rec.orig_document_number);
150: END IF;
151:
152: -- bug 2393138
153: wsh_delivery_util.g_inbound_flag := TRUE;

Line 173: wsh_debug_sv.log (l_module_name,'Parameters Not Null');

169: AND (l_trns_history_rec.trading_partner_id IS NOT NULL)
170: THEN
171:
172: IF l_debug_on THEN
173: wsh_debug_sv.log (l_module_name,'Parameters Not Null');
174: END IF;
175:
176: IF (l_trns_history_rec.document_direction NOT IN ('I'))
177: THEN

Line 197: wsh_debug_sv.log (l_module_name,'Valid Parameters');

193: RAISE invalid_entity_type;
194: END IF;
195:
196: IF l_debug_on THEN
197: wsh_debug_sv.log (l_module_name,'Valid Parameters');
198: END IF;
199:
200: IF (l_trns_history_rec.entity_type = 'DLVY_INT')
201: THEN

Line 208: wsh_debug_sv.log (l_module_name,'After Calling Derive IDS l_return_status',l_return_status);

204:
205: Derive_ids (l_delivery_interface_id,l_trns_history_rec.document_type,l_return_status);
206:
207: IF l_debug_on THEN
208: wsh_debug_sv.log (l_module_name,'After Calling Derive IDS l_return_status',l_return_status);
209: END IF;
210:
211: IF (l_return_status = wsh_util_core.g_ret_sts_success) THEN
212:

Line 225: wsh_debug_sv.log (l_module_name,'l_delivery_interface_id',l_delivery_interface_id);

221: t_return_status
222: );
223:
224: IF l_debug_on THEN
225: wsh_debug_sv.log (l_module_name,'l_delivery_interface_id',l_delivery_interface_id);
226: wsh_debug_sv.log (l_module_name,'x_delivery_id',x_delivery_id);
227: wsh_debug_sv.log (l_module_name,'t_return_status',t_return_status);
228: END IF;
229:

Line 226: wsh_debug_sv.log (l_module_name,'x_delivery_id',x_delivery_id);

222: );
223:
224: IF l_debug_on THEN
225: wsh_debug_sv.log (l_module_name,'l_delivery_interface_id',l_delivery_interface_id);
226: wsh_debug_sv.log (l_module_name,'x_delivery_id',x_delivery_id);
227: wsh_debug_sv.log (l_module_name,'t_return_status',t_return_status);
228: END IF;
229:
230: ELSE

Line 227: wsh_debug_sv.log (l_module_name,'t_return_status',t_return_status);

223:
224: IF l_debug_on THEN
225: wsh_debug_sv.log (l_module_name,'l_delivery_interface_id',l_delivery_interface_id);
226: wsh_debug_sv.log (l_module_name,'x_delivery_id',x_delivery_id);
227: wsh_debug_sv.log (l_module_name,'t_return_status',t_return_status);
228: END IF;
229:
230: ELSE
231: wsh_inbound_ship_advice_pkg.process_ship_advice (

Line 238: wsh_debug_sv.log (l_module_name,'t_return_status',t_return_status);

234: t_return_status
235: );
236:
237: IF l_debug_on THEN
238: wsh_debug_sv.log (l_module_name,'t_return_status',t_return_status);
239: END IF;
240:
241: END IF;
242:

Line 281: wsh_debug_sv.log (l_module_name,'Ship Request or Advice Succeeded');

277: END IF; --}
278: END IF; --}
279:
280: IF l_debug_on THEN
281: wsh_debug_sv.log (l_module_name,'Ship Request or Advice Succeeded');
282: END IF;
283:
284: -- Update done only for 'SR' because , for 'SA', update
285: -- done in ship_advice_pkg

Line 300: wsh_debug_sv.log (l_module_name, 'Return status after delete interface records', X_Return_Status);

296: Delete_Interface_Records(
297: L_Delivery_Interface_ID,
298: X_Return_Status);
299: IF l_debug_on THEN
300: wsh_debug_sv.log (l_module_name, 'Return status after delete interface records', X_Return_Status);
301: END IF;
302: END IF;
303:
304: ELSE --}

Line 306: wsh_debug_sv.log (l_module_name, 'Ship Request or Advice error');

302: END IF;
303:
304: ELSE --}
305: IF l_debug_on THEN
306: wsh_debug_sv.log (l_module_name, 'Ship Request or Advice error');
307: END IF;
308: -- Update done only for 'SR' because , for 'SA', update
309: -- done in ship_advice_pkg
310: UPDATE wsh_transactions_history

Line 333: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

329: );
330: --
331: --
332: IF l_debug_on THEN
333: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
334: END IF;
335: --
336: --
337: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

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

359: --
360: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
361: --{
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
364: END IF;
365:
366: l_reset_flags := FALSE;
367:

Line 372: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

368: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
369: x_return_status => l_return_status);
370:
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
373: END IF;
374:
375: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
376: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 411: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

407: );
408: --
409: --
410: IF l_debug_on THEN
411: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
412: END IF;
413: --
414: --
415: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

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

427: --
428: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
429: --{
430: IF l_debug_on THEN
431: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433:
434: l_reset_flags := FALSE;
435:

Line 440: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

436: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
437: x_return_status => l_return_status);
438:
439: IF l_debug_on THEN
440: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
441: END IF;
442:
443: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
444: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

471: --{
472: l_reset_flags := TRUE;
473:
474: IF l_debug_on THEN
475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
476: END IF;
477:
478: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
479: x_return_status => l_return_status);

Line 482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

478: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
479: x_return_status => l_return_status);
480:
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
483: END IF;
484:
485: IF (
486: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

Line 506: wsh_debug_sv.log (l_module_name,'Return Status',X_Return_Status);

502: END IF;
503: --bug 4070732
504:
505: IF l_debug_on THEN
506: wsh_debug_sv.log (l_module_name,'Return Status',X_Return_Status);
507: wsh_debug_sv.pop (l_module_name);
508: END IF;
509:
510: --wsh_debug_sv.stop_other_app_debug('OE', l_return_status);

Line 507: wsh_debug_sv.pop (l_module_name);

503: --bug 4070732
504:
505: IF l_debug_on THEN
506: wsh_debug_sv.log (l_module_name,'Return Status',X_Return_Status);
507: wsh_debug_sv.pop (l_module_name);
508: END IF;
509:
510: --wsh_debug_sv.stop_other_app_debug('OE', l_return_status);
511: wsh_debug_sv.stop_debug;

Line 510: --wsh_debug_sv.stop_other_app_debug('OE', l_return_status);

506: wsh_debug_sv.log (l_module_name,'Return Status',X_Return_Status);
507: wsh_debug_sv.pop (l_module_name);
508: END IF;
509:
510: --wsh_debug_sv.stop_other_app_debug('OE', l_return_status);
511: wsh_debug_sv.stop_debug;
512: EXCEPTION
513: WHEN FND_API.G_EXC_ERROR THEN
514: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 511: wsh_debug_sv.stop_debug;

507: wsh_debug_sv.pop (l_module_name);
508: END IF;
509:
510: --wsh_debug_sv.stop_other_app_debug('OE', l_return_status);
511: wsh_debug_sv.stop_debug;
512: EXCEPTION
513: WHEN FND_API.G_EXC_ERROR THEN
514: x_return_status := FND_API.G_RET_STS_ERROR ;
515: --

Line 522: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

518: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
519: THEN
520: --{
521: IF l_debug_on THEN
522: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
523: END IF;
524:
525: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
526: (

Line 534: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

530: );
531: --
532: --
533: IF l_debug_on THEN
534: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
535: END IF;
536: --
537: --
538: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

552: --{
553: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
554: --{
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
557: END IF;
558:
559: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
560: x_return_status => l_return_status);

Line 563: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

559: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
560: x_return_status => l_return_status);
561:
562: IF l_debug_on THEN
563: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
564: END IF;
565:
566: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
567: x_return_status := l_return_status;

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

574: -- End of Code Bugfix 4070732
575: --
576:
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
580: END IF;
581: --
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

575: --
576:
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
580: END IF;
581: --
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 591: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

587: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
588: THEN
589: --{
590: IF l_debug_on THEN
591: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
592: END IF;
593:
594: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
595: (

Line 603: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

599: );
600: --
601: --
602: IF l_debug_on THEN
603: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
604: END IF;
605: --
606: --
607: --}

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

617: --{
618: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
619: --{
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
622: END IF;
623:
624: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
625: x_return_status => l_return_status);

Line 628: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

624: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
625: x_return_status => l_return_status);
626:
627: IF l_debug_on THEN
628: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
629: END IF;
630: --}
631: END IF;
632: --}

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

634: --
635: -- End of Code Bugfix 4070732
636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
640: END IF;
641: --
642: WHEN invalid_doc_direction

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

635: -- End of Code Bugfix 4070732
636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
640: END IF;
641: --
642: WHEN invalid_doc_direction
643: THEN

Line 652: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

648: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
649: THEN
650: --{
651: IF l_debug_on THEN
652: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
653: END IF;
654:
655: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
656: (

Line 664: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

660: );
661: --
662: --
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
665: END IF;
666: --
667: --
668: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

682: --{
683: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
684: --{
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
687: END IF;
688:
689: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
690: x_return_status => l_return_status);

Line 693: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

689: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
690: x_return_status => l_return_status);
691:
692: IF l_debug_on THEN
693: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
694: END IF;
695:
696: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
697: x_return_status := l_return_status;

Line 708: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

704: -- End of Code Bugfix 4070732
705: --
706:
707: IF l_debug_on THEN
708: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
709: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
710: END IF;
711: wsh_debug_sv.stop_debug;
712: WHEN invalid_doc_type

Line 709: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');

705: --
706:
707: IF l_debug_on THEN
708: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
709: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
710: END IF;
711: wsh_debug_sv.stop_debug;
712: WHEN invalid_doc_type
713: THEN

Line 711: wsh_debug_sv.stop_debug;

707: IF l_debug_on THEN
708: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
709: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
710: END IF;
711: wsh_debug_sv.stop_debug;
712: WHEN invalid_doc_type
713: THEN
714: x_return_status := wsh_util_core.g_ret_sts_error;
715:

Line 723: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

719: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
720: THEN
721: --{
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
724: END IF;
725:
726: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
727: (

Line 735: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

731: );
732: --
733: --
734: IF l_debug_on THEN
735: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
736: END IF;
737: --
738: --
739: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

753: --{
754: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
755: --{
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
758: END IF;
759:
760: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
761: x_return_status => l_return_status);

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

760: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
761: x_return_status => l_return_status);
762:
763: IF l_debug_on THEN
764: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
765: END IF;
766:
767: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
768: x_return_status := l_return_status;

Line 779: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

775: -- End of Code Bugfix 4070732
776: --
777:
778: IF l_debug_on THEN
779: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
780: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
781: END IF;
782: wsh_debug_sv.stop_debug;
783: WHEN invalid_action_type

Line 780: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');

776: --
777:
778: IF l_debug_on THEN
779: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
780: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
781: END IF;
782: wsh_debug_sv.stop_debug;
783: WHEN invalid_action_type
784: THEN

Line 782: wsh_debug_sv.stop_debug;

778: IF l_debug_on THEN
779: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
780: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
781: END IF;
782: wsh_debug_sv.stop_debug;
783: WHEN invalid_action_type
784: THEN
785: x_return_status := wsh_util_core.g_ret_sts_error;
786: --

Line 793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

789: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
790: THEN
791: --{
792: IF l_debug_on THEN
793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
794: END IF;
795:
796: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
797: (

Line 805: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

801: );
802: --
803: --
804: IF l_debug_on THEN
805: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
806: END IF;
807: --
808: --
809: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

824: --{
825: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
826: --{
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
829: END IF;
830:
831: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
832: x_return_status => l_return_status);

Line 835: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

831: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
832: x_return_status => l_return_status);
833:
834: IF l_debug_on THEN
835: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
836: END IF;
837:
838: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
839: x_return_status := l_return_status;

Line 850: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

846: -- End of Code Bugfix 4070732
847: --
848:
849: IF l_debug_on THEN
850: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
852: END IF;
853: wsh_debug_sv.stop_debug;
854: WHEN invalid_entity_type

Line 851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');

847: --
848:
849: IF l_debug_on THEN
850: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
852: END IF;
853: wsh_debug_sv.stop_debug;
854: WHEN invalid_entity_type
855: THEN

Line 853: wsh_debug_sv.stop_debug;

849: IF l_debug_on THEN
850: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
852: END IF;
853: wsh_debug_sv.stop_debug;
854: WHEN invalid_entity_type
855: THEN
856: x_return_status := wsh_util_core.g_ret_sts_error;
857:

Line 865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

861: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
862: THEN
863: --{
864: IF l_debug_on THEN
865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
866: END IF;
867:
868: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
869: (

Line 877: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

873: );
874: --
875: --
876: IF l_debug_on THEN
877: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
878: END IF;
879: --
880: --
881: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

895: --{
896: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
897: --{
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
900: END IF;
901:
902: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
903: x_return_status => l_return_status);

Line 906: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

902: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
903: x_return_status => l_return_status);
904:
905: IF l_debug_on THEN
906: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
907: END IF;
908:
909: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
910: x_return_status := l_return_status;

Line 921: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

917: -- End of Code Bugfix 4070732
918: --
919:
920: IF l_debug_on THEN
921: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
923: END IF;
924: wsh_debug_sv.stop_debug;
925: WHEN OTHERS

Line 922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');

918: --
919:
920: IF l_debug_on THEN
921: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
923: END IF;
924: wsh_debug_sv.stop_debug;
925: WHEN OTHERS
926: THEN

Line 924: wsh_debug_sv.stop_debug;

920: IF l_debug_on THEN
921: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
923: END IF;
924: wsh_debug_sv.stop_debug;
925: WHEN OTHERS
926: THEN
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
928: IF l_debug_on THEN

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

925: WHEN OTHERS
926: THEN
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
928: IF l_debug_on THEN
929: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
930: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
931: END IF;
932: --
933: -- K LPN CONV. rv

Line 930: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

926: THEN
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
928: IF l_debug_on THEN
929: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
930: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
931: END IF;
932: --
933: -- K LPN CONV. rv
934: --

Line 939: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

935: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
936: THEN
937: --{
938: IF l_debug_on THEN
939: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
940: END IF;
941:
942: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
943: (

Line 951: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

947: );
948: --
949: --
950: IF l_debug_on THEN
951: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
952: END IF;
953: --
954: --
955: --}

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

962: --
963: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
964: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
967: END IF;
968:
969: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
970: x_return_status => l_return_status);

Line 974: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

970: x_return_status => l_return_status);
971:
972:
973: IF l_debug_on THEN
974: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
975: END IF;
976:
977: END IF;
978: END IF;

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

980: -- End of Code Bugfix 4070732
981: --
982:
983: IF l_debug_on THEN
984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
985: END IF;
986: wsh_debug_sv.stop_debug;
987: END process_inbound;
988:

Line 986: wsh_debug_sv.stop_debug;

982:
983: IF l_debug_on THEN
984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
985: END IF;
986: wsh_debug_sv.stop_debug;
987: END process_inbound;
988:
989:
990: /*=======================================================================================

Line 1117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1113: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1114: --
1115: IF l_debug_on IS NULL
1116: THEN
1117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1118: END IF;
1119: --
1120: IF l_debug_on THEN
1121: wsh_debug_sv.push (l_module_name, 'DERIVE_IDS');

Line 1121: wsh_debug_sv.push (l_module_name, 'DERIVE_IDS');

1117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1118: END IF;
1119: --
1120: IF l_debug_on THEN
1121: wsh_debug_sv.push (l_module_name, 'DERIVE_IDS');
1122: wsh_debug_sv.log (l_module_name,'DELIVERY_INTERFACE_ID',p_delivery_interface_id);
1123: END IF;
1124:
1125: /* Check if the values passed are valid */

Line 1122: wsh_debug_sv.log (l_module_name,'DELIVERY_INTERFACE_ID',p_delivery_interface_id);

1118: END IF;
1119: --
1120: IF l_debug_on THEN
1121: wsh_debug_sv.push (l_module_name, 'DERIVE_IDS');
1122: wsh_debug_sv.log (l_module_name,'DELIVERY_INTERFACE_ID',p_delivery_interface_id);
1123: END IF;
1124:
1125: /* Check if the values passed are valid */
1126:

Line 1139: wsh_debug_sv.log (l_module_name, 'l_del_count',l_del_count);

1135: WHERE delivery_interface_id = p_delivery_interface_id
1136: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1137:
1138: IF l_debug_on THEN
1139: wsh_debug_sv.log (l_module_name, 'l_del_count',l_del_count);
1140: END IF;
1141:
1142: IF (l_del_count <> 1)
1143: THEN

Line 1150: wsh_debug_sv.log (l_module_name,'Inside Delivery Rec Loop');

1146:
1147: FOR delivery_rec IN delivery_cur
1148: LOOP
1149: IF l_debug_on THEN
1150: wsh_debug_sv.log (l_module_name,'Inside Delivery Rec Loop');
1151: wsh_debug_sv.log (l_module_name, 'Delivery Attributes');
1152: wsh_debug_sv.log (l_module_name, 'Delivery Name', delivery_rec.name);
1153: wsh_debug_sv.log (l_module_name, 'Org Code', delivery_rec.organization_code);
1154: wsh_debug_sv.log (l_module_name, 'Initial pickup', delivery_rec.initial_pickup_location_code);

Line 1151: wsh_debug_sv.log (l_module_name, 'Delivery Attributes');

1147: FOR delivery_rec IN delivery_cur
1148: LOOP
1149: IF l_debug_on THEN
1150: wsh_debug_sv.log (l_module_name,'Inside Delivery Rec Loop');
1151: wsh_debug_sv.log (l_module_name, 'Delivery Attributes');
1152: wsh_debug_sv.log (l_module_name, 'Delivery Name', delivery_rec.name);
1153: wsh_debug_sv.log (l_module_name, 'Org Code', delivery_rec.organization_code);
1154: wsh_debug_sv.log (l_module_name, 'Initial pickup', delivery_rec.initial_pickup_location_code);
1155: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff', delivery_rec.ultimate_dropoff_location_code);

Line 1152: wsh_debug_sv.log (l_module_name, 'Delivery Name', delivery_rec.name);

1148: LOOP
1149: IF l_debug_on THEN
1150: wsh_debug_sv.log (l_module_name,'Inside Delivery Rec Loop');
1151: wsh_debug_sv.log (l_module_name, 'Delivery Attributes');
1152: wsh_debug_sv.log (l_module_name, 'Delivery Name', delivery_rec.name);
1153: wsh_debug_sv.log (l_module_name, 'Org Code', delivery_rec.organization_code);
1154: wsh_debug_sv.log (l_module_name, 'Initial pickup', delivery_rec.initial_pickup_location_code);
1155: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff', delivery_rec.ultimate_dropoff_location_code);
1156: wsh_debug_sv.log (l_module_name, 'IntMed ShipTo', delivery_rec.intmed_ship_to_location_code);

Line 1153: wsh_debug_sv.log (l_module_name, 'Org Code', delivery_rec.organization_code);

1149: IF l_debug_on THEN
1150: wsh_debug_sv.log (l_module_name,'Inside Delivery Rec Loop');
1151: wsh_debug_sv.log (l_module_name, 'Delivery Attributes');
1152: wsh_debug_sv.log (l_module_name, 'Delivery Name', delivery_rec.name);
1153: wsh_debug_sv.log (l_module_name, 'Org Code', delivery_rec.organization_code);
1154: wsh_debug_sv.log (l_module_name, 'Initial pickup', delivery_rec.initial_pickup_location_code);
1155: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff', delivery_rec.ultimate_dropoff_location_code);
1156: wsh_debug_sv.log (l_module_name, 'IntMed ShipTo', delivery_rec.intmed_ship_to_location_code);
1157: wsh_debug_sv.log (l_module_name, 'Customer Name', delivery_rec.customer_name);

Line 1154: wsh_debug_sv.log (l_module_name, 'Initial pickup', delivery_rec.initial_pickup_location_code);

1150: wsh_debug_sv.log (l_module_name,'Inside Delivery Rec Loop');
1151: wsh_debug_sv.log (l_module_name, 'Delivery Attributes');
1152: wsh_debug_sv.log (l_module_name, 'Delivery Name', delivery_rec.name);
1153: wsh_debug_sv.log (l_module_name, 'Org Code', delivery_rec.organization_code);
1154: wsh_debug_sv.log (l_module_name, 'Initial pickup', delivery_rec.initial_pickup_location_code);
1155: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff', delivery_rec.ultimate_dropoff_location_code);
1156: wsh_debug_sv.log (l_module_name, 'IntMed ShipTo', delivery_rec.intmed_ship_to_location_code);
1157: wsh_debug_sv.log (l_module_name, 'Customer Name', delivery_rec.customer_name);
1158: END IF;

Line 1155: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff', delivery_rec.ultimate_dropoff_location_code);

1151: wsh_debug_sv.log (l_module_name, 'Delivery Attributes');
1152: wsh_debug_sv.log (l_module_name, 'Delivery Name', delivery_rec.name);
1153: wsh_debug_sv.log (l_module_name, 'Org Code', delivery_rec.organization_code);
1154: wsh_debug_sv.log (l_module_name, 'Initial pickup', delivery_rec.initial_pickup_location_code);
1155: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff', delivery_rec.ultimate_dropoff_location_code);
1156: wsh_debug_sv.log (l_module_name, 'IntMed ShipTo', delivery_rec.intmed_ship_to_location_code);
1157: wsh_debug_sv.log (l_module_name, 'Customer Name', delivery_rec.customer_name);
1158: END IF;
1159:

Line 1156: wsh_debug_sv.log (l_module_name, 'IntMed ShipTo', delivery_rec.intmed_ship_to_location_code);

1152: wsh_debug_sv.log (l_module_name, 'Delivery Name', delivery_rec.name);
1153: wsh_debug_sv.log (l_module_name, 'Org Code', delivery_rec.organization_code);
1154: wsh_debug_sv.log (l_module_name, 'Initial pickup', delivery_rec.initial_pickup_location_code);
1155: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff', delivery_rec.ultimate_dropoff_location_code);
1156: wsh_debug_sv.log (l_module_name, 'IntMed ShipTo', delivery_rec.intmed_ship_to_location_code);
1157: wsh_debug_sv.log (l_module_name, 'Customer Name', delivery_rec.customer_name);
1158: END IF;
1159:
1160: WSH_UTIL_VALIDATE.Validate_Org (

Line 1157: wsh_debug_sv.log (l_module_name, 'Customer Name', delivery_rec.customer_name);

1153: wsh_debug_sv.log (l_module_name, 'Org Code', delivery_rec.organization_code);
1154: wsh_debug_sv.log (l_module_name, 'Initial pickup', delivery_rec.initial_pickup_location_code);
1155: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff', delivery_rec.ultimate_dropoff_location_code);
1156: wsh_debug_sv.log (l_module_name, 'IntMed ShipTo', delivery_rec.intmed_ship_to_location_code);
1157: wsh_debug_sv.log (l_module_name, 'Customer Name', delivery_rec.customer_name);
1158: END IF;
1159:
1160: WSH_UTIL_VALIDATE.Validate_Org (
1161: l_org_id,

Line 1166: wsh_debug_sv.log (l_module_name,'Status after validate_org',x_return_status);

1162: delivery_rec.organization_code,
1163: x_return_status);
1164:
1165: IF l_debug_on THEN
1166: wsh_debug_sv.log (l_module_name,'Status after validate_org',x_return_status);
1167: END IF;
1168:
1169: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1170: THEN

Line 1185: wsh_debug_sv.logmsg(l_module_name, 'Error: Location Org match not found');

1181: IF l_op_unit_id IS NULL THEN
1182: --{
1183: --
1184: IF l_debug_on THEN
1185: wsh_debug_sv.logmsg(l_module_name, 'Error: Location Org match not found');
1186: END IF;
1187: --
1188:
1189: interface_errors_rec.p_token1 := 'Operating_unit';

Line 1215: wsh_debug_sv.log (l_module_name, 'Delivery Rec customer name is null');

1211: -- Raise an exception because that is an invalid case
1212:
1213: IF(delivery_rec.customer_name IS NULL) THEN
1214: IF l_debug_on THEN
1215: wsh_debug_sv.log (l_module_name, 'Delivery Rec customer name is null');
1216: END IF;
1217:
1218: BEGIN
1219: SELECT DISTINCT customer_name

Line 1228: wsh_debug_sv.log (l_module_name, 'Detail Rec distinct customer name', l_detail_customer_name);

1224: AND wdai.delivery_interface_id = p_delivery_interface_id
1225: AND wddi.INTERFACE_ACTION_CODE = '94X_INBOUND'
1226: AND wdai.INTERFACE_ACTION_CODE = '94X_INBOUND';
1227: IF l_debug_on THEN
1228: wsh_debug_sv.log (l_module_name, 'Detail Rec distinct customer name', l_detail_customer_name);
1229: END IF;
1230:
1231: IF l_detail_customer_name IS NOT NULL THEN
1232: delivery_rec.customer_name := l_detail_customer_name;

Line 1242: wsh_debug_sv.log (l_module_name, 'Multiple distinct customer_names for details');

1238: WHEN NO_DATA_FOUND THEN
1239: raise invalid_customer_name;
1240: WHEN TOO_MANY_ROWS THEN
1241: IF l_debug_on THEN
1242: wsh_debug_sv.log (l_module_name, 'Multiple distinct customer_names for details');
1243: END IF;
1244: raise invalid_customer_name;
1245: END;
1246: END IF; -- if delivery_rec.customer_name

Line 1253: wsh_debug_sv.log (l_module_name, 'Organization id for delivery ' || l_org_id);

1249: l_dlvy_customer_name := delivery_rec.customer_name;
1250:
1251: IF(delivery_rec.intmed_ship_to_location_code IS NOT NULL) THEN
1252: IF l_debug_on THEN
1253: wsh_debug_sv.log (l_module_name, 'Organization id for delivery ' || l_org_id);
1254: END IF;
1255:
1256: WSH_EXTERNAL_INTERFACE_SV.Validate_Ship_To(
1257: p_customer_name => delivery_rec.customer_name,

Line 1267: wsh_debug_sv.log (l_module_name,'Status after Intmed_ship_to_location_code',x_return_status);

1263: x_site_use_id => l_dummy_site_use_id);
1264:
1265:
1266: IF l_debug_on THEN
1267: wsh_debug_sv.log (l_module_name,'Status after Intmed_ship_to_location_code',x_return_status);
1268: END IF;
1269:
1270: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1271: interface_errors_rec.p_token2 := 'Intmed_Ship_To_Location_Code';

Line 1281: wsh_debug_sv.log (l_module_name,'Status after Validate Customer ',x_return_status);

1277: /*
1278: wsh_util_validate.validate_customer (l_customer_id,delivery_rec.customer_number,x_return_status);
1279:
1280: IF l_debug_on THEN
1281: wsh_debug_sv.log (l_module_name,'Status after Validate Customer ',x_return_status);
1282: END IF;
1283:
1284: IF (x_return_status = wsh_util_core.g_ret_sts_error)
1285: THEN

Line 1298: wsh_debug_sv.log (l_module_name,'Status after Initial_pickup_location ',x_return_status);

1294: delivery_rec.initial_pickup_location_code,
1295: x_return_status);
1296:
1297: IF l_debug_on THEN
1298: wsh_debug_sv.log (l_module_name,'Status after Initial_pickup_location ',x_return_status);
1299: END IF;
1300:
1301: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1302: THEN

Line 1309: wsh_debug_sv.log (l_module_name, 'Organization id for delivery - 2 ' || l_org_id);

1305: l_d_temp_status := 'INVALID';
1306: END IF;
1307:
1308: IF l_debug_on THEN
1309: wsh_debug_sv.log (l_module_name, 'Organization id for delivery - 2 ' || l_org_id);
1310: END IF;
1311: IF p_document_type <> 'SA' THEN --{ bug 3920178
1312:
1313: WSH_EXTERNAL_INTERFACE_SV.Validate_Ship_To(

Line 1324: wsh_debug_sv.log (l_module_name,'Status after ultimate_dropoff_location ',x_return_status);

1320: x_site_use_id => l_dummy_site_use_id,
1321: p_org_id => l_op_unit_id);
1322:
1323: IF l_debug_on THEN
1324: wsh_debug_sv.log (l_module_name,'Status after ultimate_dropoff_location ',x_return_status);
1325: END IF;
1326:
1327: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1328: THEN

Line 1338: wsh_debug_sv.log (l_module_name, 'l_d_temp_status',l_d_temp_status);

1334:
1335: /* Update ID fields in interface table only if all the validations succeeded */
1336:
1337: IF l_debug_on THEN
1338: wsh_debug_sv.log (l_module_name, 'l_d_temp_status',l_d_temp_status);
1339: END IF;
1340:
1341: IF (l_d_temp_status <> 'INVALID')
1342: THEN

Line 1366: wsh_debug_sv.log (l_module_name, 'log_interface_errors x_return_status',x_return_status);

1362: p_interface_errors_rec =>interface_errors_rec,
1363: p_api_name =>'WSH_EXTERNAL_INTERFACE_SV.Validate_Ship_To',
1364: x_return_status =>x_return_status);
1365: IF l_debug_on THEN
1366: wsh_debug_sv.log (l_module_name, 'log_interface_errors x_return_status',x_return_status);
1367: END IF;
1368: END IF;
1369: END LOOP;
1370:

Line 1382: wsh_debug_sv.log (l_module_name, 'Organization Code' , delivery_detail_rec.organization_code);

1378: delivery_detail_rec.organization_code,
1379: x_return_status);
1380:
1381: IF l_debug_on THEN
1382: wsh_debug_sv.log (l_module_name, 'Organization Code' , delivery_detail_rec.organization_code);
1383: wsh_debug_sv.log (l_module_name, 'Derived Org id', l_det_org_id);
1384: wsh_debug_sv.log (l_module_name, 'Status after validate org for detail',x_return_status);
1385: END IF;
1386:

Line 1383: wsh_debug_sv.log (l_module_name, 'Derived Org id', l_det_org_id);

1379: x_return_status);
1380:
1381: IF l_debug_on THEN
1382: wsh_debug_sv.log (l_module_name, 'Organization Code' , delivery_detail_rec.organization_code);
1383: wsh_debug_sv.log (l_module_name, 'Derived Org id', l_det_org_id);
1384: wsh_debug_sv.log (l_module_name, 'Status after validate org for detail',x_return_status);
1385: END IF;
1386:
1387: IF (x_return_status = wsh_util_core.g_ret_sts_error)

Line 1384: wsh_debug_sv.log (l_module_name, 'Status after validate org for detail',x_return_status);

1380:
1381: IF l_debug_on THEN
1382: wsh_debug_sv.log (l_module_name, 'Organization Code' , delivery_detail_rec.organization_code);
1383: wsh_debug_sv.log (l_module_name, 'Derived Org id', l_det_org_id);
1384: wsh_debug_sv.log (l_module_name, 'Status after validate org for detail',x_return_status);
1385: END IF;
1386:
1387: IF (x_return_status = wsh_util_core.g_ret_sts_error)
1388: THEN

Line 1405: wsh_debug_sv.logmsg(l_module_name, 'Error: Location Org match not found');

1401: THEN
1402: --{
1403: --
1404: IF l_debug_on THEN
1405: wsh_debug_sv.logmsg(l_module_name, 'Error: Location Org match not found');
1406: END IF;
1407: --
1408:
1409: interface_errors_rec.p_token1 := 'Operating_unit'; --bmso

Line 1425: wsh_debug_sv.log (l_module_name, 'Return status after validate item',X_Return_Status);

1421: x_inventory_item_id => L_Inventory_Item_ID,
1422: x_return_status =>X_Return_Status);
1423:
1424: IF l_debug_on THEN
1425: wsh_debug_sv.log (l_module_name, 'Return status after validate item',X_Return_Status);
1426: wsh_debug_sv.log (l_module_name, 'Item Number', Delivery_Detail_Rec.Item_Number);
1427: wsh_debug_sv.log (l_module_name, 'Derived Item Id', L_Inventory_Item_ID);
1428: END IF;
1429: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then

Line 1426: wsh_debug_sv.log (l_module_name, 'Item Number', Delivery_Detail_Rec.Item_Number);

1422: x_return_status =>X_Return_Status);
1423:
1424: IF l_debug_on THEN
1425: wsh_debug_sv.log (l_module_name, 'Return status after validate item',X_Return_Status);
1426: wsh_debug_sv.log (l_module_name, 'Item Number', Delivery_Detail_Rec.Item_Number);
1427: wsh_debug_sv.log (l_module_name, 'Derived Item Id', L_Inventory_Item_ID);
1428: END IF;
1429: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then
1430: Interface_Errors_rec.P_token2 := 'Item Number';

Line 1427: wsh_debug_sv.log (l_module_name, 'Derived Item Id', L_Inventory_Item_ID);

1423:
1424: IF l_debug_on THEN
1425: wsh_debug_sv.log (l_module_name, 'Return status after validate item',X_Return_Status);
1426: wsh_debug_sv.log (l_module_name, 'Item Number', Delivery_Detail_Rec.Item_Number);
1427: wsh_debug_sv.log (l_module_name, 'Derived Item Id', L_Inventory_Item_ID);
1428: END IF;
1429: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then
1430: Interface_Errors_rec.P_token2 := 'Item Number';
1431: Interface_Errors_rec.P_value2 := Delivery_Detail_Rec.Item_Number;

Line 1477: wsh_debug_sv.log (l_module_name, 'Organization id for delivery detail ',l_det_org_id);

1473: -- Ship To does not at the container level , in the inbound message
1474: -- Hence we need to validate the ship to only for non-containers.
1475: IF (delivery_detail_rec.container_flag = 'N') THEN
1476: IF l_debug_on THEN
1477: wsh_debug_sv.log (l_module_name, 'Organization id for delivery detail ',l_det_org_id);
1478: END IF;
1479: IF p_document_type <> 'SA' THEN --{ bug 3920178
1480: WSH_EXTERNAL_INTERFACE_SV.Validate_Ship_To(
1481: p_customer_name => delivery_detail_rec.customer_name,

Line 1490: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );

1486: p_site_use_code => 'SHIP_TO',
1487: x_site_use_id => l_ship_to_site_use_id);
1488:
1489: IF l_debug_on THEN
1490: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );
1491: END IF;
1492:
1493: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1494: interface_errors_rec.p_token5 := 'Ship To Location Code';

Line 1503: wsh_debug_sv.log (l_module_name, 'Organization id for delivery detail - 2' ,l_det_org_id);

1499:
1500: -- Validation for Int_Med Ship To
1501: IF(delivery_detail_rec.intmed_ship_to_location_code IS NOT NULL) THEN
1502: IF l_debug_on THEN
1503: wsh_debug_sv.log (l_module_name, 'Organization id for delivery detail - 2' ,l_det_org_id);
1504: END IF;
1505: WSH_EXTERNAL_INTERFACE_SV.Validate_Ship_To(
1506: p_customer_name => delivery_detail_rec.customer_name,
1507: p_location => delivery_detail_rec.intmed_ship_to_location_code,

Line 1515: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );

1511: p_site_use_code => 'SHIP_TO',
1512: x_site_use_id => l_ship_to_site_use_id);
1513:
1514: IF l_debug_on THEN
1515: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );
1516: END IF;
1517: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1518: interface_errors_rec.p_token6 := 'IntMed ShipTo Location Code';
1519: interface_errors_rec.p_value6 := delivery_detail_rec.intmed_ship_to_location_code;

Line 1527: wsh_debug_sv.log (l_module_name, 'Organization id for delivery detail' ,l_det_org_id);

1523:
1524: -- Validation for Deliver To
1525: IF (delivery_detail_rec.container_flag = 'N') THEN
1526: IF l_debug_on THEN
1527: wsh_debug_sv.log (l_module_name, 'Organization id for delivery detail' ,l_det_org_id);
1528: END IF;
1529:
1530: WSH_EXTERNAL_INTERFACE_SV.Validate_Ship_To(
1531: p_customer_name => delivery_detail_rec.customer_name,

Line 1542: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );

1538: --x_site_use_id => l_ship_to_site_use_id);
1539: x_site_use_id => l_deliver_to_site_use_id);
1540:
1541: IF l_debug_on THEN
1542: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );
1543: END IF;
1544:
1545: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1546: interface_errors_rec.p_token7 := 'Deliver To Location Code';

Line 1628: wsh_debug_sv.log (l_module_name, 'Delivery ID', l_dlvy_id);

1624: END IF; -- End of IF (P_Document_Type ='SR' ....
1625:
1626: /* Update ID fields in interface table only if all the validations succeeded */
1627: IF l_debug_on THEN
1628: wsh_debug_sv.log (l_module_name, 'Delivery ID', l_dlvy_id);
1629: wsh_debug_sv.log (l_module_name, 'l_dd_temp_status', l_dd_temp_status);
1630: END IF;
1631:
1632: IF (l_dd_temp_status <> 'INVALID')

Line 1629: wsh_debug_sv.log (l_module_name, 'l_dd_temp_status', l_dd_temp_status);

1625:
1626: /* Update ID fields in interface table only if all the validations succeeded */
1627: IF l_debug_on THEN
1628: wsh_debug_sv.log (l_module_name, 'Delivery ID', l_dlvy_id);
1629: wsh_debug_sv.log (l_module_name, 'l_dd_temp_status', l_dd_temp_status);
1630: END IF;
1631:
1632: IF (l_dd_temp_status <> 'INVALID')
1633: THEN

Line 1660: wsh_debug_sv.log (l_module_name, 'log_interface_errors x_return_status', x_return_status);

1656: p_interface_errors_rec =>interface_errors_rec,
1657: p_api_name => 'wsh_delivery_details_inv.validate_lot_number',
1658: x_return_status =>x_return_status);
1659: IF l_debug_on THEN
1660: wsh_debug_sv.log (l_module_name, 'log_interface_errors x_return_status', x_return_status);
1661: END IF;
1662: END IF;
1663: END LOOP;
1664:

Line 1672: wsh_debug_sv.pop (l_module_name);

1668: ELSE
1669: x_return_status := wsh_util_core.g_ret_sts_error;
1670: END IF;
1671:
1672: wsh_debug_sv.pop (l_module_name);
1673: EXCEPTION
1674: WHEN invalid_delivery_name THEN
1675: IF(dlvy_id_cur%ISOPEN) THEN
1676: CLOSE dlvy_id_cur;

Line 1680: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1676: CLOSE dlvy_id_cur;
1677: END IF;
1678: x_return_status := wsh_util_core.g_ret_sts_error;
1679: IF l_debug_on THEN
1680: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1681: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_name');
1682: END IF;
1683:
1684: WHEN invalid_delivery_int_id THEN

Line 1681: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_name');

1677: END IF;
1678: x_return_status := wsh_util_core.g_ret_sts_error;
1679: IF l_debug_on THEN
1680: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1681: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_name');
1682: END IF;
1683:
1684: WHEN invalid_delivery_int_id THEN
1685: x_return_status := wsh_util_core.g_ret_sts_error;

Line 1687: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_int_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1683:
1684: WHEN invalid_delivery_int_id THEN
1685: x_return_status := wsh_util_core.g_ret_sts_error;
1686: IF l_debug_on THEN
1687: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_int_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_int_id');
1689: END IF;
1690: WHEN invalid_customer_name THEN
1691: x_return_status := wsh_util_core.g_ret_sts_error;

Line 1688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_int_id');

1684: WHEN invalid_delivery_int_id THEN
1685: x_return_status := wsh_util_core.g_ret_sts_error;
1686: IF l_debug_on THEN
1687: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_int_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_int_id');
1689: END IF;
1690: WHEN invalid_customer_name THEN
1691: x_return_status := wsh_util_core.g_ret_sts_error;
1692: IF l_debug_on THEN

Line 1693: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_customer_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1689: END IF;
1690: WHEN invalid_customer_name THEN
1691: x_return_status := wsh_util_core.g_ret_sts_error;
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_customer_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_customer_name');
1695: END IF;
1696: WHEN OTHERS THEN
1697: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

Line 1694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_customer_name');

1690: WHEN invalid_customer_name THEN
1691: x_return_status := wsh_util_core.g_ret_sts_error;
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_customer_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_customer_name');
1695: END IF;
1696: WHEN OTHERS THEN
1697: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1698: IF l_debug_on THEN

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

1695: END IF;
1696: WHEN OTHERS THEN
1697: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1698: IF l_debug_on THEN
1699: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1700: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1701: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1702: END IF;
1703: END derive_ids;

Line 1700: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1696: WHEN OTHERS THEN
1697: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1698: IF l_debug_on THEN
1699: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1700: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1701: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1702: END IF;
1703: END derive_ids;
1704:

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

1697: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1698: IF l_debug_on THEN
1699: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1700: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1701: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1702: END IF;
1703: END derive_ids;
1704:
1705:

Line 1754: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1750: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1751: --
1752: IF l_debug_on IS NULL
1753: THEN
1754: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1755: END IF;
1756: --
1757: IF l_debug_on THEN
1758: wsh_debug_sv.push (l_module_name, 'DELETE INTERFACE RECORDS');

Line 1758: wsh_debug_sv.push (l_module_name, 'DELETE INTERFACE RECORDS');

1754: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1755: END IF;
1756: --
1757: IF l_debug_on THEN
1758: wsh_debug_sv.push (l_module_name, 'DELETE INTERFACE RECORDS');
1759: wsh_debug_sv.log ( l_module_name, 'DELIVERY INTERFACE ID', p_delivery_interface_id);
1760: END IF;
1761:
1762: SELECT COUNT (*)

Line 1759: wsh_debug_sv.log ( l_module_name, 'DELIVERY INTERFACE ID', p_delivery_interface_id);

1755: END IF;
1756: --
1757: IF l_debug_on THEN
1758: wsh_debug_sv.push (l_module_name, 'DELETE INTERFACE RECORDS');
1759: wsh_debug_sv.log ( l_module_name, 'DELIVERY INTERFACE ID', p_delivery_interface_id);
1760: END IF;
1761:
1762: SELECT COUNT (*)
1763: INTO l_del_count

Line 1809: wsh_debug_sv.pop (l_module_name);

1805: ELSE -- IF Delivery Doesnot exists
1806: RAISE invalid_delivery;
1807: END IF;
1808:
1809: wsh_debug_sv.pop (l_module_name);
1810: EXCEPTION
1811: WHEN invalid_delivery
1812: THEN
1813: x_return_status := wsh_util_core.g_ret_sts_error;

Line 1815: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1811: WHEN invalid_delivery
1812: THEN
1813: x_return_status := wsh_util_core.g_ret_sts_error;
1814: IF l_debug_on THEN
1815: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1816: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
1817: END IF;
1818: WHEN invalid_delete
1819: THEN

Line 1816: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');

1812: THEN
1813: x_return_status := wsh_util_core.g_ret_sts_error;
1814: IF l_debug_on THEN
1815: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1816: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
1817: END IF;
1818: WHEN invalid_delete
1819: THEN
1820: x_return_status := wsh_util_core.g_ret_sts_error;

Line 1822: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delete exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1818: WHEN invalid_delete
1819: THEN
1820: x_return_status := wsh_util_core.g_ret_sts_error;
1821: IF l_debug_on THEN
1822: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delete exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1823: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delete');
1824: END IF;
1825: WHEN OTHERS
1826: THEN

Line 1823: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delete');

1819: THEN
1820: x_return_status := wsh_util_core.g_ret_sts_error;
1821: IF l_debug_on THEN
1822: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delete exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1823: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delete');
1824: END IF;
1825: WHEN OTHERS
1826: THEN
1827: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

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

1825: WHEN OTHERS
1826: THEN
1827: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1830: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1831: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1832: END IF;
1833: END delete_interface_records;

Line 1830: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1826: THEN
1827: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1830: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1831: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1832: END IF;
1833: END delete_interface_records;
1834: END wsh_process_interfaced_pkg;

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

1827: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1830: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1831: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1832: END IF;
1833: END delete_interface_records;
1834: END wsh_process_interfaced_pkg;