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

Line 170: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

166: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
167: --
168: IF l_debug_on IS NULL
169: THEN
170: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
171: END IF;
172: --
173:
174: IF l_debug_on THEN

Line 175: wsh_debug_sv.push (l_module_name);

171: END IF;
172: --
173:
174: IF l_debug_on THEN
175: wsh_debug_sv.push (l_module_name);
176: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
177: wsh_debug_sv.log (l_module_name,'p_entity_type',p_entity_type);
178: wsh_debug_sv.log (l_module_name,'p_pickup_dep_date',p_pickup_dep_date);
179: wsh_debug_sv.log (l_module_name,'p_pickup_arr_date',p_pickup_arr_date);

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

172: --
173:
174: IF l_debug_on THEN
175: wsh_debug_sv.push (l_module_name);
176: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
177: wsh_debug_sv.log (l_module_name,'p_entity_type',p_entity_type);
178: wsh_debug_sv.log (l_module_name,'p_pickup_dep_date',p_pickup_dep_date);
179: wsh_debug_sv.log (l_module_name,'p_pickup_arr_date',p_pickup_arr_date);
180: wsh_debug_sv.log (l_module_name,'p_dropoff_arr_date',p_dropoff_arr_date);

Line 177: wsh_debug_sv.log (l_module_name,'p_entity_type',p_entity_type);

173:
174: IF l_debug_on THEN
175: wsh_debug_sv.push (l_module_name);
176: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
177: wsh_debug_sv.log (l_module_name,'p_entity_type',p_entity_type);
178: wsh_debug_sv.log (l_module_name,'p_pickup_dep_date',p_pickup_dep_date);
179: wsh_debug_sv.log (l_module_name,'p_pickup_arr_date',p_pickup_arr_date);
180: wsh_debug_sv.log (l_module_name,'p_dropoff_arr_date',p_dropoff_arr_date);
181: wsh_debug_sv.log (l_module_name,'p_dropoff_dep_date',p_dropoff_dep_date);

Line 178: wsh_debug_sv.log (l_module_name,'p_pickup_dep_date',p_pickup_dep_date);

174: IF l_debug_on THEN
175: wsh_debug_sv.push (l_module_name);
176: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
177: wsh_debug_sv.log (l_module_name,'p_entity_type',p_entity_type);
178: wsh_debug_sv.log (l_module_name,'p_pickup_dep_date',p_pickup_dep_date);
179: wsh_debug_sv.log (l_module_name,'p_pickup_arr_date',p_pickup_arr_date);
180: wsh_debug_sv.log (l_module_name,'p_dropoff_arr_date',p_dropoff_arr_date);
181: wsh_debug_sv.log (l_module_name,'p_dropoff_dep_date',p_dropoff_dep_date);
182: END IF;

Line 179: wsh_debug_sv.log (l_module_name,'p_pickup_arr_date',p_pickup_arr_date);

175: wsh_debug_sv.push (l_module_name);
176: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
177: wsh_debug_sv.log (l_module_name,'p_entity_type',p_entity_type);
178: wsh_debug_sv.log (l_module_name,'p_pickup_dep_date',p_pickup_dep_date);
179: wsh_debug_sv.log (l_module_name,'p_pickup_arr_date',p_pickup_arr_date);
180: wsh_debug_sv.log (l_module_name,'p_dropoff_arr_date',p_dropoff_arr_date);
181: wsh_debug_sv.log (l_module_name,'p_dropoff_dep_date',p_dropoff_dep_date);
182: END IF;
183:

Line 180: wsh_debug_sv.log (l_module_name,'p_dropoff_arr_date',p_dropoff_arr_date);

176: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
177: wsh_debug_sv.log (l_module_name,'p_entity_type',p_entity_type);
178: wsh_debug_sv.log (l_module_name,'p_pickup_dep_date',p_pickup_dep_date);
179: wsh_debug_sv.log (l_module_name,'p_pickup_arr_date',p_pickup_arr_date);
180: wsh_debug_sv.log (l_module_name,'p_dropoff_arr_date',p_dropoff_arr_date);
181: wsh_debug_sv.log (l_module_name,'p_dropoff_dep_date',p_dropoff_dep_date);
182: END IF;
183:
184: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 181: wsh_debug_sv.log (l_module_name,'p_dropoff_dep_date',p_dropoff_dep_date);

177: wsh_debug_sv.log (l_module_name,'p_entity_type',p_entity_type);
178: wsh_debug_sv.log (l_module_name,'p_pickup_dep_date',p_pickup_dep_date);
179: wsh_debug_sv.log (l_module_name,'p_pickup_arr_date',p_pickup_arr_date);
180: wsh_debug_sv.log (l_module_name,'p_dropoff_arr_date',p_dropoff_arr_date);
181: wsh_debug_sv.log (l_module_name,'p_dropoff_dep_date',p_dropoff_dep_date);
182: END IF;
183:
184: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
185:

Line 198: wsh_debug_sv.log(l_module_name,'Returning as no constraints are defined ',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

194: g_valid_const_cache.valid_const_present := FALSE;
195: g_valid_const_cache.cache_date := SYSDATE;
196:
197: IF l_debug_on THEN
198: wsh_debug_sv.log(l_module_name,'Returning as no constraints are defined ',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
199: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;
202: --

Line 199: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

195: g_valid_const_cache.cache_date := SYSDATE;
196:
197: IF l_debug_on THEN
198: wsh_debug_sv.log(l_module_name,'Returning as no constraints are defined ',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
199: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;
202: --
203: CLOSE c_get_const_count;

Line 200: WSH_DEBUG_SV.pop(l_module_name);

196:
197: IF l_debug_on THEN
198: wsh_debug_sv.log(l_module_name,'Returning as no constraints are defined ',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
199: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;
202: --
203: CLOSE c_get_const_count;
204: RETURN;

Line 213: wsh_debug_sv.log(l_module_name,'Atleast one effective constraint defined ');

209: g_valid_const_cache.valid_const_present := TRUE;
210: g_valid_const_cache.cache_date := SYSDATE;
211:
212: IF l_debug_on THEN
213: wsh_debug_sv.log(l_module_name,'Atleast one effective constraint defined ');
214: END IF;
215:
216: CLOSE c_get_const_count;
217:

Line 221: wsh_debug_sv.log(l_module_name,'Returning as no constraints are defined ',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

217:
218: ELSIF (g_valid_const_cache.valid_const_present = FALSE ) THEN
219:
220: IF l_debug_on THEN
221: wsh_debug_sv.log(l_module_name,'Returning as no constraints are defined ',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
222: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
223: WSH_DEBUG_SV.pop(l_module_name);
224: END IF;
225:

Line 222: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

218: ELSIF (g_valid_const_cache.valid_const_present = FALSE ) THEN
219:
220: IF l_debug_on THEN
221: wsh_debug_sv.log(l_module_name,'Returning as no constraints are defined ',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
222: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
223: WSH_DEBUG_SV.pop(l_module_name);
224: END IF;
225:
226: RETURN;

Line 223: WSH_DEBUG_SV.pop(l_module_name);

219:
220: IF l_debug_on THEN
221: wsh_debug_sv.log(l_module_name,'Returning as no constraints are defined ',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
222: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
223: WSH_DEBUG_SV.pop(l_module_name);
224: END IF;
225:
226: RETURN;
227:

Line 231: wsh_debug_sv.log(l_module_name,'Atleast one effective constraint defined ');

227:
228: ELSE
229:
230: IF l_debug_on THEN
231: wsh_debug_sv.log(l_module_name,'Atleast one effective constraint defined ');
232: END IF;
233:
234: END IF;
235: --DUM_LOC(E)

Line 260: wsh_debug_sv.log (l_module_name,'l_cc_action_code',l_cc_action_code);

256: END IF;
257:
258:
259: IF l_debug_on THEN
260: wsh_debug_sv.log (l_module_name,'l_cc_action_code',l_cc_action_code);
261: END IF;
262:
263: IF l_cc_action_code is not null THEN --{
264: --initialize the delivery record and the lines assigned to it

Line 377: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);

373: l_in_ids := p_in_ids;
374: END IF;--}
375:
376: IF l_debug_on THEN
377: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);
378: END IF;
379:
380: l_cc_target_tripstops.pickup_stop_id := p_pickup_stop_id;
381: l_cc_target_tripstops.pickup_stop_seq := p_pickup_stop_seq;

Line 413: wsh_debug_sv.logmsg(l_module_name,'after calling validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);

409: x_return_status => x_return_status);
410:
411:
412: IF l_debug_on THEN
413: wsh_debug_sv.logmsg(l_module_name,'after calling validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);
414: END IF;
415: END IF;-- l_cc_action_code is not null}
416: --check for delivery is over
417: ELSIF p_entity_type='L' THEN

Line 442: wsh_debug_sv.log (l_module_name,'l_cc_action_code',l_cc_action_code);

438: l_cc_action_code:='ACD';
439: END IF;
440:
441: IF l_debug_on THEN
442: wsh_debug_sv.log (l_module_name,'l_cc_action_code',l_cc_action_code);
443: END IF;
444:
445: IF l_cc_action_code is not null THEN
446: --initialize the delivery detail record

Line 531: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_dlvb',WSH_DEBUG_SV.C_PROC_LEVEL);

527: l_in_ids := p_in_ids;
528: END IF; --}
529:
530: IF l_debug_on THEN
531: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_dlvb',WSH_DEBUG_SV.C_PROC_LEVEL);
532: END IF;
533:
534: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvb(
535: p_init_msg_list => p_init_msg_list,

Line 552: wsh_debug_sv.logmsg(l_module_name,'after calling validate_constraint_dlvb',WSH_DEBUG_SV.C_PROC_LEVEL);

548: x_msg_data => x_msg_data,
549: x_return_status => x_return_status);
550:
551: IF l_debug_on THEN
552: wsh_debug_sv.logmsg(l_module_name,'after calling validate_constraint_dlvb',WSH_DEBUG_SV.C_PROC_LEVEL);
553: END IF;
554:
555: END IF;-- l_cc_action_code is not null
556:

Line 565: wsh_debug_sv.log (l_module_name,'l_cc_action_code',l_cc_action_code);

561: l_cc_action_code:='UPT';
562: END IF;
563:
564: IF l_debug_on THEN
565: wsh_debug_sv.log (l_module_name,'l_cc_action_code',l_cc_action_code);
566: END IF;
567:
568: IF l_cc_action_code is not null THEN
569: --initialize the delivery record and the lines assigned to it

Line 594: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_trip',WSH_DEBUG_SV.C_PROC_LEVEL);

590: END LOOP;
591: END IF;
592:
593: IF l_debug_on THEN
594: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_trip',WSH_DEBUG_SV.C_PROC_LEVEL);
595: END IF;
596:
597: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_trip(
598: p_init_msg_list => p_init_msg_list,

Line 612: wsh_debug_sv.logmsg(l_module_name,'after calling validate_constraint_trip',WSH_DEBUG_SV.C_PROC_LEVEL);

608: x_msg_data => x_msg_data,
609: x_return_status => x_return_status);
610:
611: IF l_debug_on THEN
612: wsh_debug_sv.logmsg(l_module_name,'after calling validate_constraint_trip',WSH_DEBUG_SV.C_PROC_LEVEL);
613: END IF;
614: END IF;-- l_cc_action_code is not null
615:
616: --check for trip is over

Line 628: wsh_debug_sv.log (l_module_name,'l_cc_action_code',l_cc_action_code);

624: l_cc_action_code:='CTS';
625: END IF;
626:
627: IF l_debug_on THEN
628: wsh_debug_sv.log (l_module_name,'l_cc_action_code',l_cc_action_code);
629: END IF;
630:
631: IF l_cc_action_code is not null THEN
632: --initialize the delivery record and the lines assigned to it

Line 670: wsh_debug_sv.log(l_module_name,'p_in_ids.COUNT passed for stops',p_in_ids.COUNT);

666: -- DUM_LOC(E)
667: END LOOP;
668: ELSIF p_in_ids.COUNT>0 THEN
669: IF l_debug_on THEN
670: wsh_debug_sv.log(l_module_name,'p_in_ids.COUNT passed for stops',p_in_ids.COUNT);
671: END IF;
672: FOR i IN p_in_ids.FIRST..p_in_ids.LAST LOOP
673: l_cc_stop_info(i).STOP_ID := p_in_ids(i);
674: END LOOP;

Line 677: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_stop',WSH_DEBUG_SV.C_PROC_LEVEL);

673: l_cc_stop_info(i).STOP_ID := p_in_ids(i);
674: END LOOP;
675: END IF;
676: IF l_debug_on THEN
677: wsh_debug_sv.logmsg(l_module_name,'before calling validate_constraint_stop',WSH_DEBUG_SV.C_PROC_LEVEL);
678: END IF;
679:
680: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_stop(
681: p_init_msg_list => p_init_msg_list,

Line 693: wsh_debug_sv.logmsg(l_module_name,'after calling validate_constraint_stop',WSH_DEBUG_SV.C_PROC_LEVEL);

689: x_msg_data => x_msg_data,
690: x_return_status => x_return_status);
691:
692: IF l_debug_on THEN
693: wsh_debug_sv.logmsg(l_module_name,'after calling validate_constraint_stop',WSH_DEBUG_SV.C_PROC_LEVEL);
694:
695: END IF;
696: END IF;-- l_cc_action_code is not null
697: --check for stop is over

Line 701: wsh_debug_sv.log(l_module_name,'l_id_tab.count',l_id_tab.count);

697: --check for stop is over
698: END IF;-- entity_type
699:
700: IF l_debug_on THEN
701: wsh_debug_sv.log(l_module_name,'l_id_tab.count',l_id_tab.count);
702: END IF;
703: IF l_id_tab.COUNT > 0 THEN
704: RAISE e_handle_supplier_managed;
705: END IF;

Line 708: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

704: RAISE e_handle_supplier_managed;
705: END IF;
706:
707: IF l_debug_on THEN
708: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
709: WSH_DEBUG_SV.pop(l_module_name);
710: END IF;
711: --
712: --

Line 709: WSH_DEBUG_SV.pop(l_module_name);

705: END IF;
706:
707: IF l_debug_on THEN
708: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_',x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
709: WSH_DEBUG_SV.pop(l_module_name);
710: END IF;
711: --
712: --
713:

Line 748: WSH_DEBUG_SV.log(l_module_name,'x_return_status', x_return_status);

744: END LOOP;
745:
746: END IF; --}
747: IF l_debug_on THEN
748: WSH_DEBUG_SV.log(l_module_name,'x_return_status', x_return_status);
749: WSH_DEBUG_SV.pop(l_module_name);
750: END IF;
751:
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 749: WSH_DEBUG_SV.pop(l_module_name);

745:
746: END IF; --}
747: IF l_debug_on THEN
748: WSH_DEBUG_SV.log(l_module_name,'x_return_status', x_return_status);
749: WSH_DEBUG_SV.pop(l_module_name);
750: END IF;
751:
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
754: --
755: IF l_debug_on THEN
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
758: END IF;
759: --
760: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
754: --
755: IF l_debug_on THEN
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
758: END IF;
759: --
760: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 764: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

760: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
762: --
763: IF l_debug_on THEN
764: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
765: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
766: END IF;
767:
768: WHEN OTHERS THEN

Line 765: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
762: --
763: IF l_debug_on THEN
764: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
765: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
766: END IF;
767:
768: WHEN OTHERS THEN
769: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

772: END IF;
773: wsh_util_core.default_handler('validate_constraint_main');
774: --
775: IF l_debug_on THEN
776: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
777: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
778: END IF;
779: --
780: END validate_constraint_main;

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

773: wsh_util_core.default_handler('validate_constraint_main');
774: --
775: IF l_debug_on THEN
776: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
777: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
778: END IF;
779: --
780: END validate_constraint_main;
781:

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

840: l_target_trip_tab WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
841: l_dummy_target_lane WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_tab_type;
842: l_parent_delivery_leg_id NUMBER;
843:
844: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
845: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'validate_constraint_dlegui';
846:
847: BEGIN
848:

Line 859: wsh_debug_sv.push(l_module_name);

855: END IF;
856: CLOSE c_get_parent_delivery_leg;
857:
858: IF l_debug_on THEN
859: wsh_debug_sv.push(l_module_name);
860: WSH_DEBUG_SV.logmsg(l_module_name,'p_init_msg_list : '||p_init_msg_list);
861: WSH_DEBUG_SV.logmsg(l_module_name,'p_action_code : '||p_action_code);
862: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_leg_id : '||p_delivery_leg_id);
863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);

Line 860: WSH_DEBUG_SV.logmsg(l_module_name,'p_init_msg_list : '||p_init_msg_list);

856: CLOSE c_get_parent_delivery_leg;
857:
858: IF l_debug_on THEN
859: wsh_debug_sv.push(l_module_name);
860: WSH_DEBUG_SV.logmsg(l_module_name,'p_init_msg_list : '||p_init_msg_list);
861: WSH_DEBUG_SV.logmsg(l_module_name,'p_action_code : '||p_action_code);
862: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_leg_id : '||p_delivery_leg_id);
863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);
864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);

Line 861: WSH_DEBUG_SV.logmsg(l_module_name,'p_action_code : '||p_action_code);

857:
858: IF l_debug_on THEN
859: wsh_debug_sv.push(l_module_name);
860: WSH_DEBUG_SV.logmsg(l_module_name,'p_init_msg_list : '||p_init_msg_list);
861: WSH_DEBUG_SV.logmsg(l_module_name,'p_action_code : '||p_action_code);
862: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_leg_id : '||p_delivery_leg_id);
863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);
864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);
865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);

Line 862: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_leg_id : '||p_delivery_leg_id);

858: IF l_debug_on THEN
859: wsh_debug_sv.push(l_module_name);
860: WSH_DEBUG_SV.logmsg(l_module_name,'p_init_msg_list : '||p_init_msg_list);
861: WSH_DEBUG_SV.logmsg(l_module_name,'p_action_code : '||p_action_code);
862: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_leg_id : '||p_delivery_leg_id);
863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);
864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);
865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);
866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);

Line 863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);

859: wsh_debug_sv.push(l_module_name);
860: WSH_DEBUG_SV.logmsg(l_module_name,'p_init_msg_list : '||p_init_msg_list);
861: WSH_DEBUG_SV.logmsg(l_module_name,'p_action_code : '||p_action_code);
862: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_leg_id : '||p_delivery_leg_id);
863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);
864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);
865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);
866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);
867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);

Line 864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);

860: WSH_DEBUG_SV.logmsg(l_module_name,'p_init_msg_list : '||p_init_msg_list);
861: WSH_DEBUG_SV.logmsg(l_module_name,'p_action_code : '||p_action_code);
862: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_leg_id : '||p_delivery_leg_id);
863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);
864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);
865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);
866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);
867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);
868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);

Line 865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);

861: WSH_DEBUG_SV.logmsg(l_module_name,'p_action_code : '||p_action_code);
862: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_leg_id : '||p_delivery_leg_id);
863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);
864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);
865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);
866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);
867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);
868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);
869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);

Line 866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);

862: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_leg_id : '||p_delivery_leg_id);
863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);
864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);
865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);
866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);
867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);
868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);
869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);
870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);

Line 867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);

863: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id : '||p_delivery_id);
864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);
865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);
866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);
867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);
868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);
869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);
870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);
871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);

Line 868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);

864: WSH_DEBUG_SV.logmsg(l_module_name,'p_sequence_num : '||p_sequence_num);
865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);
866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);
867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);
868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);
869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);
870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);
871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);
872: WSH_DEBUG_SV.logmsg(l_module_name,'p_carrier_id : '||p_carrier_id);

Line 869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);

865: WSH_DEBUG_SV.logmsg(l_module_name,'p_location1_id : '||p_location1_id);
866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);
867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);
868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);
869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);
870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);
871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);
872: WSH_DEBUG_SV.logmsg(l_module_name,'p_carrier_id : '||p_carrier_id);
873: WSH_DEBUG_SV.logmsg(l_module_name,'p_mode_code : '||p_mode_code);

Line 870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);

866: WSH_DEBUG_SV.logmsg(l_module_name,'p_location2_id : '||p_location2_id);
867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);
868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);
869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);
870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);
871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);
872: WSH_DEBUG_SV.logmsg(l_module_name,'p_carrier_id : '||p_carrier_id);
873: WSH_DEBUG_SV.logmsg(l_module_name,'p_mode_code : '||p_mode_code);
874: WSH_DEBUG_SV.logmsg(l_module_name,'p_service_level : '||p_service_level);

Line 871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);

867: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop1_id : '||p_stop1_id);
868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);
869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);
870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);
871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);
872: WSH_DEBUG_SV.logmsg(l_module_name,'p_carrier_id : '||p_carrier_id);
873: WSH_DEBUG_SV.logmsg(l_module_name,'p_mode_code : '||p_mode_code);
874: WSH_DEBUG_SV.logmsg(l_module_name,'p_service_level : '||p_service_level);
875: WSH_DEBUG_SV.logmsg(l_module_name,'l_parent_delivery_leg_id : '||l_parent_delivery_leg_id);

Line 872: WSH_DEBUG_SV.logmsg(l_module_name,'p_carrier_id : '||p_carrier_id);

868: WSH_DEBUG_SV.logmsg(l_module_name,'p_stop2_id : '||p_stop2_id);
869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);
870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);
871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);
872: WSH_DEBUG_SV.logmsg(l_module_name,'p_carrier_id : '||p_carrier_id);
873: WSH_DEBUG_SV.logmsg(l_module_name,'p_mode_code : '||p_mode_code);
874: WSH_DEBUG_SV.logmsg(l_module_name,'p_service_level : '||p_service_level);
875: WSH_DEBUG_SV.logmsg(l_module_name,'l_parent_delivery_leg_id : '||l_parent_delivery_leg_id);
876: END IF;

Line 873: WSH_DEBUG_SV.logmsg(l_module_name,'p_mode_code : '||p_mode_code);

869: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_1 : '||p_date_1);
870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);
871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);
872: WSH_DEBUG_SV.logmsg(l_module_name,'p_carrier_id : '||p_carrier_id);
873: WSH_DEBUG_SV.logmsg(l_module_name,'p_mode_code : '||p_mode_code);
874: WSH_DEBUG_SV.logmsg(l_module_name,'p_service_level : '||p_service_level);
875: WSH_DEBUG_SV.logmsg(l_module_name,'l_parent_delivery_leg_id : '||l_parent_delivery_leg_id);
876: END IF;
877:

Line 874: WSH_DEBUG_SV.logmsg(l_module_name,'p_service_level : '||p_service_level);

870: WSH_DEBUG_SV.logmsg(l_module_name,'p_date_2 : '||p_date_2);
871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);
872: WSH_DEBUG_SV.logmsg(l_module_name,'p_carrier_id : '||p_carrier_id);
873: WSH_DEBUG_SV.logmsg(l_module_name,'p_mode_code : '||p_mode_code);
874: WSH_DEBUG_SV.logmsg(l_module_name,'p_service_level : '||p_service_level);
875: WSH_DEBUG_SV.logmsg(l_module_name,'l_parent_delivery_leg_id : '||l_parent_delivery_leg_id);
876: END IF;
877:
878: l_delivery_leg_rec.DELIVERY_LEG_ID := p_delivery_leg_id;

Line 875: WSH_DEBUG_SV.logmsg(l_module_name,'l_parent_delivery_leg_id : '||l_parent_delivery_leg_id);

871: WSH_DEBUG_SV.logmsg(l_module_name,'p_target_trip_id : '||p_target_trip_id);
872: WSH_DEBUG_SV.logmsg(l_module_name,'p_carrier_id : '||p_carrier_id);
873: WSH_DEBUG_SV.logmsg(l_module_name,'p_mode_code : '||p_mode_code);
874: WSH_DEBUG_SV.logmsg(l_module_name,'p_service_level : '||p_service_level);
875: WSH_DEBUG_SV.logmsg(l_module_name,'l_parent_delivery_leg_id : '||l_parent_delivery_leg_id);
876: END IF;
877:
878: l_delivery_leg_rec.DELIVERY_LEG_ID := p_delivery_leg_id;
879: l_delivery_leg_rec.DELIVERY_ID := p_delivery_id;

Line 935: WSH_DEBUG_SV.pop(l_module_name);

931: END IF;
932:
933: --
934: IF l_debug_on THEN
935: WSH_DEBUG_SV.pop(l_module_name);
936: END IF;
937: --
938:
939: EXCEPTION

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

940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
942: --
943: IF l_debug_on THEN
944: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
945: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
946: END IF;
947: --
948: WHEN others THEN

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

941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
942: --
943: IF l_debug_on THEN
944: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
945: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
946: END IF;
947: --
948: WHEN others THEN
949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

948: WHEN others THEN
949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
950: --
951: IF l_debug_on THEN
952: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
953: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
954: END IF;
955: --
956:

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

949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
950: --
951: IF l_debug_on THEN
952: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
953: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
954: END IF;
955: --
956:
957: END validate_constraint_dleg;