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_UTIL_CORE

Line 23: p_in_ids IN wsh_util_core.id_tab_type,

19: p_del_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,
20: p_det_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
21: p_trip_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
22: p_stop_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
23: p_in_ids IN wsh_util_core.id_tab_type,
24: p_pickup_stop_id IN NUMBER DEFAULT NULL,
25: p_pickup_loc_id IN NUMBER DEFAULT NULL,
26: p_pickup_stop_seq IN NUMBER DEFAULT NULL,
27: p_dropoff_stop_id IN NUMBER DEFAULT NULL,

Line 38: x_fail_ids OUT NOCOPY wsh_util_core.id_tab_type,

34: x_validate_result OUT NOCOPY VARCHAR2,
35: x_failed_lines OUT NOCOPY failed_line_tab_type,
36: x_line_groups OUT NOCOPY line_group_tab_type,
37: x_group_info OUT NOCOPY cc_group_tab_type,
38: x_fail_ids OUT NOCOPY wsh_util_core.id_tab_type,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,
41: x_msg_data OUT NOCOPY VARCHAR2
42: )

Line 81: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;

77: l_cc_parent_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
78: l_cc_parent_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
79: l_cc_parent_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
80:
81: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
82: l_id_tab WSH_UTIL_CORE.id_tab_type;
83: l_in_ids WSH_UTIL_CORE.id_tab_type;
84:
85: l_index NUMBER := 1;

Line 82: l_id_tab WSH_UTIL_CORE.id_tab_type;

78: l_cc_parent_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
79: l_cc_parent_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
80:
81: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
82: l_id_tab WSH_UTIL_CORE.id_tab_type;
83: l_in_ids WSH_UTIL_CORE.id_tab_type;
84:
85: l_index NUMBER := 1;
86: l_index2 NUMBER := 1;

Line 83: l_in_ids WSH_UTIL_CORE.id_tab_type;

79: l_cc_parent_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
80:
81: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
82: l_id_tab WSH_UTIL_CORE.id_tab_type;
83: l_in_ids WSH_UTIL_CORE.id_tab_type;
84:
85: l_index NUMBER := 1;
86: l_index2 NUMBER := 1;
87: j NUMBER;

Line 184: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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:
186: --#DUM_LOC(S)
187: IF (g_valid_const_cache.valid_const_present IS NULL OR g_valid_const_cache.cache_date <> SYSDATE) THEN
188:

Line 273: = wsh_util_core.C_NULL_SF_LOCN_ID)

269: to the constraint engine
270: */
271: IF (NVL(p_del_attr_tab(i).shipping_control,'BUYER') = 'SUPPLIER')
272: OR (p_del_attr_tab(i).INITIAL_PICKUP_LOCATION_ID
273: = wsh_util_core.C_NULL_SF_LOCN_ID)
274: OR(( p_action_code = 'ASSIGN-TRIP' )
275: AND ( p_del_attr_tab(i).shipment_direction NOT in ('O','IO'))
276: AND (p_del_attr_tab(i).status_code IN ('IT','CL')))
277: THEN --{

Line 331: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

327: l_index2 := l_index2 + 1;
328: END IF;--}
329: END LOOP; --}
330: IF l_cc_delivery_info.COUNT = 0 THEN
331: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
332: RAISE e_handle_supplier_managed;
333: END IF;
334: --
335: -- rlanka-Pack J : Treat trip-consolidation just like autocreate-trip

Line 355: (l_initial_pickup_location_id = wsh_util_core.C_NULL_SF_LOCN_ID )

351: CLOSE c_delivery_shipping_control;
352:
353: IF (l_shipping_control = 'SUPPLIER' )
354: OR
355: (l_initial_pickup_location_id = wsh_util_core.C_NULL_SF_LOCN_ID )
356: OR (( l_shipment_direction NOT in ('O','IO'))
357: AND (l_status_code IN ('IT','CL')))
358:
359: THEN

Line 369: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

365: END IF;
366: j := p_in_ids.NEXT(j);
367: END LOOP;
368: IF l_in_ids.COUNT = 0 THEN
369: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
370: RAISE e_handle_supplier_managed;
371: END IF;
372: ELSE --}{
373: l_in_ids := p_in_ids;

Line 452: wsh_util_core.C_NULL_SF_LOCN_ID)

448: IF p_det_attr_tab.COUNT>0 THEN --{
449: FOR i IN p_det_attr_tab.FIRST..p_det_attr_tab.LAST LOOP --{
450: IF ((NVL(p_det_attr_tab(i).shipping_control,'BUYER') = 'SUPPLIER')
451: OR (p_det_attr_tab(i).ship_from_location_id =
452: wsh_util_core.C_NULL_SF_LOCN_ID)
453: OR ((p_det_attr_tab(i).line_direction NOT IN ('O','IO'))
454: AND (p_det_attr_tab(i).released_status IN ('C','L','P'))
455: AND (p_action_code = 'AUTOCREATE-DEL')))
456: THEN --{

Line 491: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

487: END IF; --}
488:
489: END LOOP; --}
490: IF l_cc_del_detail_info.COUNT = 0 THEN
491: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
492: RAISE e_handle_supplier_managed;
493: END IF;
494: ELSIF p_action_code = 'AUTOCREATE-DEL' AND p_in_ids.COUNT > 0 THEN--}{
495:

Line 509: OR (l_ship_from_location_id=wsh_util_core.C_NULL_SF_LOCN_ID)

505: l_line_direction,
506: l_released_status;
507: CLOSE c_shipping_control;
508: IF ((l_shipping_control = 'SUPPLIER')
509: OR (l_ship_from_location_id=wsh_util_core.C_NULL_SF_LOCN_ID)
510: OR ((l_line_direction NOT IN ('O','IO'))
511: AND (l_released_status IN ('C','L','P'))))
512: THEN
513: l_id_tab(l_index) := p_in_ids(j);

Line 523: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

519: j := p_in_ids.NEXT(j);
520: END LOOP;
521:
522: IF l_in_ids.COUNT = 0 THEN
523: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
524: RAISE e_handle_supplier_managed;
525: END IF;
526: ELSE --}{
527: l_in_ids := p_in_ids;

Line 753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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 ;
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');

Line 760: WHEN WSH_UTIL_CORE.G_EXC_WARNING 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;
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);

Line 761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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;
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');

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 769: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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 ;
770: IF c_get_const_count%ISOPEN THEN
771: CLOSE c_get_const_count;
772: END IF;
773: wsh_util_core.default_handler('validate_constraint_main');

Line 773: wsh_util_core.default_handler('validate_constraint_main');

769: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
770: IF c_get_const_count%ISOPEN THEN
771: CLOSE c_get_const_count;
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');

Line 835: l_succ_trips WSH_UTIL_CORE.id_tab_type;

831: AND DELIVERY_ID = c_del_id;
832:
833: l_return_status VARCHAR2(1);
834: l_validate_result VARCHAR2(1) := 'S';
835: l_succ_trips WSH_UTIL_CORE.id_tab_type;
836: l_dummy_succ_lanes WSH_UTIL_CORE.id_tab_type;
837: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
838: l_delivery_leg_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;
839: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;

Line 836: l_dummy_succ_lanes WSH_UTIL_CORE.id_tab_type;

832:
833: l_return_status VARCHAR2(1);
834: l_validate_result VARCHAR2(1) := 'S';
835: l_succ_trips WSH_UTIL_CORE.id_tab_type;
836: l_dummy_succ_lanes WSH_UTIL_CORE.id_tab_type;
837: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
838: l_delivery_leg_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;
839: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
840: l_target_trip_tab WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;

Line 837: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;

833: l_return_status VARCHAR2(1);
834: l_validate_result VARCHAR2(1) := 'S';
835: l_succ_trips WSH_UTIL_CORE.id_tab_type;
836: l_dummy_succ_lanes WSH_UTIL_CORE.id_tab_type;
837: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
838: l_delivery_leg_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;
839: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
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;

Line 849: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

845: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'validate_constraint_dlegui';
846:
847: BEGIN
848:
849: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
850:
851: OPEN c_get_parent_delivery_leg(p_delivery_id, p_delivery_leg_id);
852: FETCH c_get_parent_delivery_leg INTO l_parent_delivery_leg_id;
853: IF c_get_parent_delivery_leg %NOTFOUND THEN

Line 926: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

922: x_msg_count => x_msg_count, -- Standard FND functionality
923: x_msg_data => x_msg_data, -- Will return message text only if number of messages = 1
924: x_return_status => l_return_status);
925:
926: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
927:
928: raise FND_API.G_EXC_UNEXPECTED_ERROR;
929: ELSE
930: x_return_status := l_return_status;

Line 941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

937: --
938:
939: EXCEPTION
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');

Line 949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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;
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');