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.FTE_ACS_PKG dependencies on WSH_DEBUG_SV

Line 121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

117: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
118: --
119: IF l_debug_on IS NULL
120: THEN
121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
122: END IF;
123: --
124: --
125: -- Debug Statements

Line 128: WSH_DEBUG_SV.push(l_module_name);

124: --
125: -- Debug Statements
126: --
127: IF l_debug_on THEN
128: WSH_DEBUG_SV.push(l_module_name);
129: --
130: WSH_DEBUG_SV.log(l_module_name,'P_QUERY_ID',P_QUERY_ID);
131: END IF;
132: --

Line 130: WSH_DEBUG_SV.log(l_module_name,'P_QUERY_ID',P_QUERY_ID);

126: --
127: IF l_debug_on THEN
128: WSH_DEBUG_SV.push(l_module_name);
129: --
130: WSH_DEBUG_SV.log(l_module_name,'P_QUERY_ID',P_QUERY_ID);
131: END IF;
132: --
133: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
134: x_return_message := null;

Line 191: WSH_DEBUG_SV.pop(l_module_name);

187: --
188: -- Debug Statements
189: --
190: IF l_debug_on THEN
191: WSH_DEBUG_SV.pop(l_module_name);
192: END IF;
193: --
194: RETURN;
195:

Line 200: WSH_DEBUG_SV.pop(l_module_name);

196: --
197: -- Debug Statements
198: --
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;
202: --
203: EXCEPTION
204: WHEN OTHERS THEN

Line 210: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_ACS_PKG.LOG_CS_MESSAGES IS ' ||L_ERROR_TEXT );

206: --
207: -- Debug Statements
208: --
209: IF l_debug_on THEN
210: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_ACS_PKG.LOG_CS_MESSAGES IS ' ||L_ERROR_TEXT );
211: END IF;
212: --
213: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.LOG_CS_MESSAGES');
214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 220: WSH_DEBUG_SV.pop(l_module_name);

216: --
217: -- Debug Statements
218: --
219: IF l_debug_on THEN
220: WSH_DEBUG_SV.pop(l_module_name);
221: END IF;
222: --
223: RETURN;
224:

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

225: --
226: -- Debug Statements
227: --
228: IF l_debug_on THEN
229: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
231: END IF;
232: --
233: END LOG_CS_MESSAGES;

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

226: -- Debug Statements
227: --
228: IF l_debug_on THEN
229: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
231: END IF;
232: --
233: END LOG_CS_MESSAGES;
234:

Line 281: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

277: l_return_status VARCHAR2(1);
278: l_msg_count NUMBER;
279: l_msg_data VARCHAR2(2000);
280:
281: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
282: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'log_exceptions';
283:
284: BEGIN
285:

Line 287: WSH_DEBUG_SV.PUSH(l_module_name);

283:
284: BEGIN
285:
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.PUSH(l_module_name);
288: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
289: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
290: WSH_DEBUG_SV.log(l_module_name,'p_use_gtt',p_use_gtt);
291: END IF;

Line 288: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);

284: BEGIN
285:
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.PUSH(l_module_name);
288: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
289: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
290: WSH_DEBUG_SV.log(l_module_name,'p_use_gtt',p_use_gtt);
291: END IF;
292:

Line 289: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);

285:
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.PUSH(l_module_name);
288: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
289: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
290: WSH_DEBUG_SV.log(l_module_name,'p_use_gtt',p_use_gtt);
291: END IF;
292:
293: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 290: WSH_DEBUG_SV.log(l_module_name,'p_use_gtt',p_use_gtt);

286: IF l_debug_on THEN
287: WSH_DEBUG_SV.PUSH(l_module_name);
288: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
289: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
290: WSH_DEBUG_SV.log(l_module_name,'p_use_gtt',p_use_gtt);
291: END IF;
292:
293: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
294:

Line 302: WSH_DEBUG_SV.logmsg(l_module_name,'Number of Failed Entites'||l_failed_entity_tab.COUNT);

298: FETCH c_get_failed_entities BULK COLLECT INTO l_failed_entity_tab;
299: CLOSE c_get_failed_entities;
300:
301: IF l_debug_on THEN
302: WSH_DEBUG_SV.logmsg(l_module_name,'Number of Failed Entites'||l_failed_entity_tab.COUNT);
303: END IF;
304:
305: IF (l_failed_entity_tab.COUNT > 0) THEN
306:

Line 384: WSH_DEBUG_SV.log(l_module_name,'p_single_rec.rule_id ',p_single_rec.rule_id);

380: END IF;
381: ELSE
382:
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.log(l_module_name,'p_single_rec.rule_id ',p_single_rec.rule_id);
385: END IF;
386:
387: -- Only if the rule id is NULL, we need to log exception.
388: IF (p_single_rec.rule_id IS NULL) THEN

Line 450: WSH_DEBUG_SV.logmsg(l_module_name,'Logged the Exceptions');

446: END IF; --IF (p_single_rec.rule_id IS NULL) THEN
447: END IF;
448:
449: IF l_debug_on THEN
450: WSH_DEBUG_SV.logmsg(l_module_name,'Logged the Exceptions');
451: WSH_DEBUG_SV.POP (l_module_name);
452: END IF;
453:
454: EXCEPTION

Line 451: WSH_DEBUG_SV.POP (l_module_name);

447: END IF;
448:
449: IF l_debug_on THEN
450: WSH_DEBUG_SV.logmsg(l_module_name,'Logged the Exceptions');
451: WSH_DEBUG_SV.POP (l_module_name);
452: END IF;
453:
454: EXCEPTION
455: WHEN OTHERS THEN

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

461: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.log_exceptions');
462: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
463:
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
467: END IF;
468: --
469: END LOG_EXCEPTIONS;

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

462: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
463:
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
467: END IF;
468: --
469: END LOG_EXCEPTIONS;
470:

Line 529: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

525:
526: l_min_transit_time NUMBER;
527: l_max_transit_time NUMBER;
528:
529: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
530: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_FORMAT_RESULTS';
531:
532: BEGIN
533:

Line 537: wsh_debug_sv.push (l_module_name);

533:
534: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
535:
536: IF l_debug_on THEN
537: wsh_debug_sv.push (l_module_name);
538: END IF;
539:
540: IF (p_use_gtt) THEN
541:

Line 596: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);

592: x_result_tab => l_result_tab,
593: x_return_status => l_return_status);
594:
595: IF l_debug_on THEN
596: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
597: END IF;
598:
599: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
600: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 648: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);

644: x_return_status => l_return_status,
645: x_return_message => l_return_message);
646:
647: IF l_debug_on THEN
648: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
649: END IF;
650:
651: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
652: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 722: WSH_DEBUG_SV.logmsg(l_module_name,'NEW RECORD **');

718:
719: itr := x_cs_output_tab.FIRST;
720: IF (itr IS NOT NULL) THEN
721: LOOP
722: WSH_DEBUG_SV.logmsg(l_module_name,'****NEW RECORD ******');
723: WSH_DEBUG_SV.log(l_module_name,'Rule_id ',x_cs_output_tab(itr).rule_id);
724: WSH_DEBUG_SV.log(l_module_name,'Rule_name ',x_cs_output_tab(itr).rule_name);
725: WSH_DEBUG_SV.log(l_module_name,'Delivery_id ',x_cs_output_tab(itr).delivery_id);
726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);

Line 723: WSH_DEBUG_SV.log(l_module_name,'Rule_id ',x_cs_output_tab(itr).rule_id);

719: itr := x_cs_output_tab.FIRST;
720: IF (itr IS NOT NULL) THEN
721: LOOP
722: WSH_DEBUG_SV.logmsg(l_module_name,'****NEW RECORD ******');
723: WSH_DEBUG_SV.log(l_module_name,'Rule_id ',x_cs_output_tab(itr).rule_id);
724: WSH_DEBUG_SV.log(l_module_name,'Rule_name ',x_cs_output_tab(itr).rule_name);
725: WSH_DEBUG_SV.log(l_module_name,'Delivery_id ',x_cs_output_tab(itr).delivery_id);
726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);
727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);

Line 724: WSH_DEBUG_SV.log(l_module_name,'Rule_name ',x_cs_output_tab(itr).rule_name);

720: IF (itr IS NOT NULL) THEN
721: LOOP
722: WSH_DEBUG_SV.logmsg(l_module_name,'****NEW RECORD ******');
723: WSH_DEBUG_SV.log(l_module_name,'Rule_id ',x_cs_output_tab(itr).rule_id);
724: WSH_DEBUG_SV.log(l_module_name,'Rule_name ',x_cs_output_tab(itr).rule_name);
725: WSH_DEBUG_SV.log(l_module_name,'Delivery_id ',x_cs_output_tab(itr).delivery_id);
726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);
727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);
728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);

Line 725: WSH_DEBUG_SV.log(l_module_name,'Delivery_id ',x_cs_output_tab(itr).delivery_id);

721: LOOP
722: WSH_DEBUG_SV.logmsg(l_module_name,'****NEW RECORD ******');
723: WSH_DEBUG_SV.log(l_module_name,'Rule_id ',x_cs_output_tab(itr).rule_id);
724: WSH_DEBUG_SV.log(l_module_name,'Rule_name ',x_cs_output_tab(itr).rule_name);
725: WSH_DEBUG_SV.log(l_module_name,'Delivery_id ',x_cs_output_tab(itr).delivery_id);
726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);
727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);
728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);
729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);

Line 726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);

722: WSH_DEBUG_SV.logmsg(l_module_name,'****NEW RECORD ******');
723: WSH_DEBUG_SV.log(l_module_name,'Rule_id ',x_cs_output_tab(itr).rule_id);
724: WSH_DEBUG_SV.log(l_module_name,'Rule_name ',x_cs_output_tab(itr).rule_name);
725: WSH_DEBUG_SV.log(l_module_name,'Delivery_id ',x_cs_output_tab(itr).delivery_id);
726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);
727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);
728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);
729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);
730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);

Line 727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);

723: WSH_DEBUG_SV.log(l_module_name,'Rule_id ',x_cs_output_tab(itr).rule_id);
724: WSH_DEBUG_SV.log(l_module_name,'Rule_name ',x_cs_output_tab(itr).rule_name);
725: WSH_DEBUG_SV.log(l_module_name,'Delivery_id ',x_cs_output_tab(itr).delivery_id);
726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);
727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);
728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);
729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);
730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);
731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);

Line 728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);

724: WSH_DEBUG_SV.log(l_module_name,'Rule_name ',x_cs_output_tab(itr).rule_name);
725: WSH_DEBUG_SV.log(l_module_name,'Delivery_id ',x_cs_output_tab(itr).delivery_id);
726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);
727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);
728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);
729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);
730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);
731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);
732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);

Line 729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);

725: WSH_DEBUG_SV.log(l_module_name,'Delivery_id ',x_cs_output_tab(itr).delivery_id);
726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);
727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);
728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);
729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);
730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);
731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);
732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);
733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);

Line 730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);

726: WSH_DEBUG_SV.log(l_module_name,'Initial_pickup_location_id ',x_cs_output_tab(itr).initial_pickup_location_id);
727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);
728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);
729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);
730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);
731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);
732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);
733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);
734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);

Line 731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);

727: WSH_DEBUG_SV.log(l_module_name,'Ultimate_dropoff_location_id ',x_cs_output_tab(itr).ultimate_dropoff_location_id);
728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);
729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);
730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);
731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);
732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);
733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);
734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);
735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);

Line 732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);

728: WSH_DEBUG_SV.log(l_module_name,'Trip_id ',x_cs_output_tab(itr).trip_id);
729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);
730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);
731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);
732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);
733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);
734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);
735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);
736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);

Line 733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);

729: WSH_DEBUG_SV.log(l_module_name,'Result_type ',x_cs_output_tab(itr).result_type);
730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);
731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);
732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);
733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);
734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);
735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);
736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);
737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);

Line 734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);

730: WSH_DEBUG_SV.log(l_module_name,'Rank ',x_cs_output_tab(itr).rank);
731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);
732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);
733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);
734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);
735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);
736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);
737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);
738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);

Line 735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);

731: WSH_DEBUG_SV.log(l_module_name,'Leg_destination ',x_cs_output_tab(itr).leg_destination);
732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);
733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);
734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);
735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);
736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);
737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);
738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);
739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);

Line 736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);

732: WSH_DEBUG_SV.log(l_module_name,'Leg_sequence ',x_cs_output_tab(itr).leg_sequence);
733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);
734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);
735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);
736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);
737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);
738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);
739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);
740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);

Line 737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);

733: WSH_DEBUG_SV.log(l_module_name,'Carrier_id ',x_cs_output_tab(itr).carrier_id);
734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);
735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);
736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);
737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);
738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);
739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);
740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);
741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);

Line 738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);

734: WSH_DEBUG_SV.log(l_module_name,'Mode_of_transport ',x_cs_output_tab(itr).mode_of_transport);
735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);
736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);
737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);
738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);
739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);
740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);
741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);
742: WSH_DEBUG_SV.log(l_module_name,'Min_transit_time ',x_cs_output_tab(itr).min_transit_time);

Line 739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);

735: WSH_DEBUG_SV.log(l_module_name,'Service_level ',x_cs_output_tab(itr).service_level);
736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);
737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);
738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);
739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);
740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);
741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);
742: WSH_DEBUG_SV.log(l_module_name,'Min_transit_time ',x_cs_output_tab(itr).min_transit_time);
743: WSH_DEBUG_SV.log(l_module_name,'Max_transit_time ',x_cs_output_tab(itr).max_transit_time);

Line 740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);

736: WSH_DEBUG_SV.log(l_module_name,'Ship_method_code ',x_cs_output_tab(itr).ship_method_code);
737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);
738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);
739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);
740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);
741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);
742: WSH_DEBUG_SV.log(l_module_name,'Min_transit_time ',x_cs_output_tab(itr).min_transit_time);
743: WSH_DEBUG_SV.log(l_module_name,'Max_transit_time ',x_cs_output_tab(itr).max_transit_time);
744: WSH_DEBUG_SV.log(l_module_name,'Append_flag ',x_cs_output_tab(itr).append_flag);

Line 741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);

737: WSH_DEBUG_SV.log(l_module_name,'Freight_terms_code ',x_cs_output_tab(itr).freight_terms_code);
738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);
739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);
740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);
741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);
742: WSH_DEBUG_SV.log(l_module_name,'Min_transit_time ',x_cs_output_tab(itr).min_transit_time);
743: WSH_DEBUG_SV.log(l_module_name,'Max_transit_time ',x_cs_output_tab(itr).max_transit_time);
744: WSH_DEBUG_SV.log(l_module_name,'Append_flag ',x_cs_output_tab(itr).append_flag);
745: --WSH_DEBUG_SV.log(l_module_name,'Routing_rule_id ',x_cs_output_tab(itr).routing_rule_id);

Line 742: WSH_DEBUG_SV.log(l_module_name,'Min_transit_time ',x_cs_output_tab(itr).min_transit_time);

738: WSH_DEBUG_SV.log(l_module_name,'Consignee_carrier_ac_no ',x_cs_output_tab(itr).consignee_carrier_ac_no);
739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);
740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);
741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);
742: WSH_DEBUG_SV.log(l_module_name,'Min_transit_time ',x_cs_output_tab(itr).min_transit_time);
743: WSH_DEBUG_SV.log(l_module_name,'Max_transit_time ',x_cs_output_tab(itr).max_transit_time);
744: WSH_DEBUG_SV.log(l_module_name,'Append_flag ',x_cs_output_tab(itr).append_flag);
745: --WSH_DEBUG_SV.log(l_module_name,'Routing_rule_id ',x_cs_output_tab(itr).routing_rule_id);
746:

Line 743: WSH_DEBUG_SV.log(l_module_name,'Max_transit_time ',x_cs_output_tab(itr).max_transit_time);

739: WSH_DEBUG_SV.log(l_module_name,'Result_level ',x_cs_output_tab(itr).result_level);
740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);
741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);
742: WSH_DEBUG_SV.log(l_module_name,'Min_transit_time ',x_cs_output_tab(itr).min_transit_time);
743: WSH_DEBUG_SV.log(l_module_name,'Max_transit_time ',x_cs_output_tab(itr).max_transit_time);
744: WSH_DEBUG_SV.log(l_module_name,'Append_flag ',x_cs_output_tab(itr).append_flag);
745: --WSH_DEBUG_SV.log(l_module_name,'Routing_rule_id ',x_cs_output_tab(itr).routing_rule_id);
746:
747: EXIT WHEN itr = x_cs_output_tab.LAST;

Line 744: WSH_DEBUG_SV.log(l_module_name,'Append_flag ',x_cs_output_tab(itr).append_flag);

740: WSH_DEBUG_SV.log(l_module_name,'Pickup_date ',x_cs_output_tab(itr).pickup_date);
741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);
742: WSH_DEBUG_SV.log(l_module_name,'Min_transit_time ',x_cs_output_tab(itr).min_transit_time);
743: WSH_DEBUG_SV.log(l_module_name,'Max_transit_time ',x_cs_output_tab(itr).max_transit_time);
744: WSH_DEBUG_SV.log(l_module_name,'Append_flag ',x_cs_output_tab(itr).append_flag);
745: --WSH_DEBUG_SV.log(l_module_name,'Routing_rule_id ',x_cs_output_tab(itr).routing_rule_id);
746:
747: EXIT WHEN itr = x_cs_output_tab.LAST;
748: itr := x_cs_output_tab.NEXT(itr);

Line 745: --WSH_DEBUG_SV.log(l_module_name,'Routing_rule_id ',x_cs_output_tab(itr).routing_rule_id);

741: WSH_DEBUG_SV.log(l_module_name,'Dropoff_date ',x_cs_output_tab(itr).dropoff_date);
742: WSH_DEBUG_SV.log(l_module_name,'Min_transit_time ',x_cs_output_tab(itr).min_transit_time);
743: WSH_DEBUG_SV.log(l_module_name,'Max_transit_time ',x_cs_output_tab(itr).max_transit_time);
744: WSH_DEBUG_SV.log(l_module_name,'Append_flag ',x_cs_output_tab(itr).append_flag);
745: --WSH_DEBUG_SV.log(l_module_name,'Routing_rule_id ',x_cs_output_tab(itr).routing_rule_id);
746:
747: EXIT WHEN itr = x_cs_output_tab.LAST;
748: itr := x_cs_output_tab.NEXT(itr);
749: END LOOP;

Line 751: wsh_debug_sv.pop(l_module_name);

747: EXIT WHEN itr = x_cs_output_tab.LAST;
748: itr := x_cs_output_tab.NEXT(itr);
749: END LOOP;
750: END IF;
751: wsh_debug_sv.pop(l_module_name);
752: END IF;
753: EXCEPTION
754: WHEN OTHERS THEN
755: IF (c_get_rules_for_entity%ISOPEN) THEN

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

767: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');
768: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
769: --
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
772: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
773: END IF;
774: END GET_FORMAT_RESULTS;
775:

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

768: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
769: --
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
772: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
773: END IF;
774: END GET_FORMAT_RESULTS;
775:
776:

Line 824: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

820:
821: l_rule_id NUMBER;
822: l_cnt NUMBER;
823:
824: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
825: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_ROUTING_RESULTS';
826: BEGIN
827:
828: IF l_debug_on THEN

Line 829: wsh_debug_sv.push (l_module_name);

825: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_ROUTING_RESULTS';
826: BEGIN
827:
828: IF l_debug_on THEN
829: wsh_debug_sv.push (l_module_name);
830: END IF;
831:
832: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
833:

Line 845: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);

841: p_entity => p_entity,
842: x_return_status => l_return_status);
843:
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
846: END IF;
847:
848: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
849: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 885: WSH_DEBUG_SV.logmsg(l_module_name,'*NEW RECORD ******');

881: l_cnt := l_cnt+1;
882: END IF;
883: l_search_level_tab(l_cnt) := 'E'; -- Enterprise
884: IF l_debug_on THEN
885: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
886: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',l_entity_rec.delivery_id);
887: WSH_DEBUG_SV.log(l_module_name,'trip_id ',l_entity_rec.trip_id);
888: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',l_entity_rec.delivery_name);
889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);

Line 886: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',l_entity_rec.delivery_id);

882: END IF;
883: l_search_level_tab(l_cnt) := 'E'; -- Enterprise
884: IF l_debug_on THEN
885: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
886: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',l_entity_rec.delivery_id);
887: WSH_DEBUG_SV.log(l_module_name,'trip_id ',l_entity_rec.trip_id);
888: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',l_entity_rec.delivery_name);
889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);
890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);

Line 887: WSH_DEBUG_SV.log(l_module_name,'trip_id ',l_entity_rec.trip_id);

883: l_search_level_tab(l_cnt) := 'E'; -- Enterprise
884: IF l_debug_on THEN
885: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
886: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',l_entity_rec.delivery_id);
887: WSH_DEBUG_SV.log(l_module_name,'trip_id ',l_entity_rec.trip_id);
888: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',l_entity_rec.delivery_name);
889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);
890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);
891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);

Line 888: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',l_entity_rec.delivery_name);

884: IF l_debug_on THEN
885: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
886: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',l_entity_rec.delivery_id);
887: WSH_DEBUG_SV.log(l_module_name,'trip_id ',l_entity_rec.trip_id);
888: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',l_entity_rec.delivery_name);
889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);
890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);
891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);
892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);

Line 889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);

885: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
886: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',l_entity_rec.delivery_id);
887: WSH_DEBUG_SV.log(l_module_name,'trip_id ',l_entity_rec.trip_id);
888: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',l_entity_rec.delivery_name);
889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);
890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);
891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);
892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);
893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);

Line 890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);

886: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',l_entity_rec.delivery_id);
887: WSH_DEBUG_SV.log(l_module_name,'trip_id ',l_entity_rec.trip_id);
888: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',l_entity_rec.delivery_name);
889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);
890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);
891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);
892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);
893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);
894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);

Line 891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);

887: WSH_DEBUG_SV.log(l_module_name,'trip_id ',l_entity_rec.trip_id);
888: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',l_entity_rec.delivery_name);
889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);
890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);
891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);
892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);
893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);
894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);
895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);

Line 892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);

888: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',l_entity_rec.delivery_name);
889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);
890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);
891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);
892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);
893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);
894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);
895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);
896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);

Line 893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);

889: WSH_DEBUG_SV.log(l_module_name,'trip_name ',l_entity_rec.trip_name);
890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);
891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);
892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);
893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);
894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);
895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);
896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);
897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);

Line 894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);

890: WSH_DEBUG_SV.log(l_module_name,'organization_id ',l_entity_rec.organization_id);
891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);
892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);
893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);
894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);
895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);
896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);
897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);
898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);

Line 895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);

891: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',l_entity_rec.triporigin_internalorg_id);
892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);
893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);
894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);
895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);
896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);
897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);
898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);
899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);

Line 896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);

892: WSH_DEBUG_SV.log(l_module_name,'customer_id ',l_entity_rec.customer_id);
893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);
894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);
895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);
896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);
897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);
898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);
899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);
900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));

Line 897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);

893: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',l_entity_rec.customer_site_id);
894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);
895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);
896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);
897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);
898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);
899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);
900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));
901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);

Line 898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);

894: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', l_entity_rec.gross_weight);
895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);
896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);
897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);
898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);
899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);
900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));
901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);
902: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',l_entity_rec.freight_terms_code);

Line 899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);

895: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',l_entity_rec.weight_uom_code);
896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);
897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);
898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);
899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);
900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));
901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);
902: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',l_entity_rec.freight_terms_code);
903: WSH_DEBUG_SV.log(l_module_name,'fob_code ',l_entity_rec.fob_code);

Line 900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));

896: WSH_DEBUG_SV.log(l_module_name,'volume ', l_entity_rec.volume);
897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);
898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);
899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);
900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));
901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);
902: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',l_entity_rec.freight_terms_code);
903: WSH_DEBUG_SV.log(l_module_name,'fob_code ',l_entity_rec.fob_code);
904: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',l_entity_rec.start_search_level);

Line 901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);

897: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', l_entity_rec.volume_uom_code);
898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);
899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);
900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));
901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);
902: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',l_entity_rec.freight_terms_code);
903: WSH_DEBUG_SV.log(l_module_name,'fob_code ',l_entity_rec.fob_code);
904: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',l_entity_rec.start_search_level);
905: WSH_DEBUG_SV.log(l_module_name,'transit_time ',l_entity_rec.transit_time);

Line 902: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',l_entity_rec.freight_terms_code);

898: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', l_entity_rec.initial_pickup_loc_id);
899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);
900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));
901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);
902: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',l_entity_rec.freight_terms_code);
903: WSH_DEBUG_SV.log(l_module_name,'fob_code ',l_entity_rec.fob_code);
904: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',l_entity_rec.start_search_level);
905: WSH_DEBUG_SV.log(l_module_name,'transit_time ',l_entity_rec.transit_time);
906: END IF;

Line 903: WSH_DEBUG_SV.log(l_module_name,'fob_code ',l_entity_rec.fob_code);

899: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', l_entity_rec.ultimate_dropoff_loc_id);
900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));
901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);
902: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',l_entity_rec.freight_terms_code);
903: WSH_DEBUG_SV.log(l_module_name,'fob_code ',l_entity_rec.fob_code);
904: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',l_entity_rec.start_search_level);
905: WSH_DEBUG_SV.log(l_module_name,'transit_time ',l_entity_rec.transit_time);
906: END IF;
907: ELSE

Line 904: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',l_entity_rec.start_search_level);

900: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(l_entity_rec.initial_pickup_date,SYSDATE));
901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);
902: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',l_entity_rec.freight_terms_code);
903: WSH_DEBUG_SV.log(l_module_name,'fob_code ',l_entity_rec.fob_code);
904: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',l_entity_rec.start_search_level);
905: WSH_DEBUG_SV.log(l_module_name,'transit_time ',l_entity_rec.transit_time);
906: END IF;
907: ELSE
908:

Line 905: WSH_DEBUG_SV.log(l_module_name,'transit_time ',l_entity_rec.transit_time);

901: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', l_entity_rec.ultimate_dropoff_date);
902: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',l_entity_rec.freight_terms_code);
903: WSH_DEBUG_SV.log(l_module_name,'fob_code ',l_entity_rec.fob_code);
904: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',l_entity_rec.start_search_level);
905: WSH_DEBUG_SV.log(l_module_name,'transit_time ',l_entity_rec.transit_time);
906: END IF;
907: ELSE
908:
909: /*

Line 929: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);

925: FTE_ACS_RULE_UTIL_PKG.INSERT_INTO_GTT( p_input_data => p_format_cs_tab,
926: x_return_status => l_return_status);
927:
928: IF l_debug_on THEN
929: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
930: END IF;
931:
932: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
933: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1003: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);

999: x_output_tab => l_output_tab,
1000: x_return_status => l_return_status);
1001:
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
1004: END IF;
1005:
1006: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1007: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1032: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);

1028: x_rule_id => l_rule_id,
1029: x_return_status => l_return_status);
1030:
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
1033: WSH_DEBUG_SV.log(l_module_name,'l_rule_id ',l_rule_id);
1034: END IF;
1035:
1036: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1033: WSH_DEBUG_SV.log(l_module_name,'l_rule_id ',l_rule_id);

1029: x_return_status => l_return_status);
1030:
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
1033: WSH_DEBUG_SV.log(l_module_name,'l_rule_id ',l_rule_id);
1034: END IF;
1035:
1036: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1037: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1099: WSH_DEBUG_SV.log(l_module_name,'l_entities_left ',l_entities_left);

1095: -- If data not there then log exceptions.
1096: --
1097:
1098: IF l_debug_on THEN
1099: WSH_DEBUG_SV.log(l_module_name,'l_entities_left ',l_entities_left);
1100: END IF;
1101:
1102: --
1103: -- In case of single records need to call get_format_resutls only when entity is

Line 1118: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);

1114: x_cs_output_tab => x_cs_output_tab,
1115: x_return_status => l_return_status);
1116:
1117: IF l_debug_on THEN
1118: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
1119: END IF;
1120:
1121: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1122: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1144: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);

1140: x_cs_output_message_tab => x_cs_output_message_tab,
1141: x_return_status => l_return_status);
1142:
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
1145: END IF;
1146:
1147: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1148: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1168: wsh_debug_sv.pop (l_module_name);

1164:
1165: END IF;
1166:
1167: IF l_debug_on THEN
1168: wsh_debug_sv.pop (l_module_name);
1169: END IF;
1170:
1171: EXCEPTION
1172:

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

1175: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');
1176: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1177: --
1178: IF l_debug_on THEN
1179: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1180: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1181: END IF;
1182:
1183: WHEN OTHERS THEN

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

1176: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1177: --
1178: IF l_debug_on THEN
1179: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1180: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1181: END IF;
1182:
1183: WHEN OTHERS THEN
1184: --

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

1185: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');
1186: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1187: --
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1191: END IF;
1192:
1193: END GET_ROUTING_RESULTS;

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

1186: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1187: --
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1191: END IF;
1192:
1193: END GET_ROUTING_RESULTS;
1194: