eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_UTIL_CORE

Line 43: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

39: p_line_rows IN OUT NOCOPY wsh_delivery_autocreate.grp_attr_tab_type,
40: p_group_by_header IN VARCHAR2,
41: p_check_fte_compatibility IN VARCHAR2,
42: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
43: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
44: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
45: x_return_status OUT NOCOPY VARCHAR2) IS
46:
47:

Line 44: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

40: p_group_by_header IN VARCHAR2,
41: p_check_fte_compatibility IN VARCHAR2,
42: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
43: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
44: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
45: x_return_status OUT NOCOPY VARCHAR2) IS
46:
47:
48:

Line 54: l_cc_in_ids WSH_UTIL_CORE.id_tab_type;

50: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
51: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
52: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
53: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
54: l_cc_in_ids WSH_UTIL_CORE.id_tab_type;
55: l_cc_fail_ids WSH_UTIL_CORE.id_tab_type;
56: l_cc_validate_result VARCHAR2(1);
57: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
58: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;

Line 55: l_cc_fail_ids WSH_UTIL_CORE.id_tab_type;

51: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
52: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
53: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
54: l_cc_in_ids WSH_UTIL_CORE.id_tab_type;
55: l_cc_fail_ids WSH_UTIL_CORE.id_tab_type;
56: l_cc_validate_result VARCHAR2(1);
57: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
58: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
59: l_cc_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;

Line 80: l_matched_entities WSH_UTIL_CORE.id_tab_type;

76: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
77: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
78: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
79: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
80: l_matched_entities WSH_UTIL_CORE.id_tab_type;
81: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
82:
83:
84: l_index NUMBER;

Line 90: l_cc_group_ids WSH_UTIL_CORE.id_tab_type;

86:
87: l_cc_groupExists BOOLEAN;
88: l_delivery_done BOOLEAN;
89: l_multiple_sub_groups BOOLEAN;
90: l_cc_group_ids WSH_UTIL_CORE.id_tab_type;
91:
92: l_get_autocreate_del_criteria VARCHAR2(1);
93: l_warning_num NUMBER := 0;
94: i NUMBER;

Line 143: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

139:
140: -- OTM R12 : update delivery
141: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
142: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
143: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
144: l_tms_update VARCHAR2(1);
145: l_trip_not_found VARCHAR2(1);
146: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
147: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;

Line 169: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

165: END IF;
166:
167:
168:
169: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
170: -- OTM R12
171: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
172:
173: IF (l_gc3_is_installed IS NULL) THEN

Line 171: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

167:
168:
169: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
170: -- OTM R12
171: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
172:
173: IF (l_gc3_is_installed IS NULL) THEN
174: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
175: END IF;

Line 174: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

170: -- OTM R12
171: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
172:
173: IF (l_gc3_is_installed IS NULL) THEN
174: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
175: END IF;
176: -- End of OTM R12
177:
178:

Line 223: IF wsh_util_core.fte_is_installed = 'Y'

219: l_cc_line_groups.delete;
220:
221:
222: -- construct
223: IF wsh_util_core.fte_is_installed = 'Y'
224: AND p_check_fte_compatibility = FND_API.G_TRUE
225: AND l_cc_in_ids.count > 1 THEN
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main');

Line 256: IF l_cc_line_groups.COUNT > 0 AND l_return_status = wsh_util_core.g_ret_sts_error THEN

252:
253: -- x_fail_ids and x_failed_lines are not populated for AUTOCREATE-DEL
254: l_cc_group_ids.delete;
255:
256: IF l_cc_line_groups.COUNT > 0 AND l_return_status = wsh_util_core.g_ret_sts_error THEN
257:
258: i := l_cc_line_groups.FIRST;
259: WHILE i is NOT NULL LOOP
260:

Line 441: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

437: l_tms_update := 'N';
438: l_new_interface_flag_tab(1) := NULL;
439:
440: -- delivery update will be done only for SUCCESS, WARNING case
441: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
442: WSH_UTIL_CORE.G_RET_STS_WARNING) AND
443: l_gc3_is_installed = 'Y' AND
444: nvl(l_ignore_for_planning, 'N') = 'N') THEN
445: -- l_otm_return_status is used here not to change l_return_status

Line 442: WSH_UTIL_CORE.G_RET_STS_WARNING) AND

438: l_new_interface_flag_tab(1) := NULL;
439:
440: -- delivery update will be done only for SUCCESS, WARNING case
441: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
442: WSH_UTIL_CORE.G_RET_STS_WARNING) AND
443: l_gc3_is_installed = 'Y' AND
444: nvl(l_ignore_for_planning, 'N') = 'N') THEN
445: -- l_otm_return_status is used here not to change l_return_status
446: -- from the above API call

Line 456: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

452: (p_delivery_id => l_delivery_id,
453: x_trip_info_rec => l_trip_info_rec,
454: x_return_status => l_otm_return_status);
455:
456: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
457: x_return_status := l_otm_return_status;
458: IF l_debug_on THEN
459: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
460: WSH_DEBUG_SV.pop(l_module_name);

Line 478: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

474: p_delivery_id => l_delivery_id,
475: x_delivery_rec => l_delivery_info,
476: x_return_status => l_otm_return_status);
477:
478: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
479: x_return_status := l_otm_return_status;
480: IF l_debug_on THEN
481: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
482: WSH_DEBUG_SV.pop(l_module_name);

Line 529: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

525:
526: -- If there are some delivery details assigned to the delivery,
527: -- we populate the assigned table and delete it from the main table
528:
529: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
530:
531: IF l_debug_on THEN
532: i := l_action_out_rec.result_id_tab.FIRST;
533: WHILE i is not NULL LOOP

Line 572: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR , WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN

568: p_delivery_id => l_delivery_id,
569: p_delivery_detail_id => l_details_in_cc_group(i).delivery_detail_id);
570:
571:
572: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR , WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
573: IF l_debug_on THEN
574: WSH_DEBUG_SV.log(l_module_name,' log_exception failed ');
575: END IF;
576: raise log_exception_err;

Line 653: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

649: WSH_XC_UTIL.LOG_OTM_EXCEPTION(
650: p_delivery_info_tab => l_delivery_info_tab,
651: p_new_interface_flag_tab => l_new_interface_flag_tab,
652: x_return_status => l_otm_return_status);
653: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
654: x_return_status := l_otm_return_status;
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
657: WSH_DEBUG_SV.pop(l_module_name);

Line 674: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING /* some of them are successfully

670: END IF;
671: i := l_cc_group_ids.next(i);
672: END LOOP;
673:
674: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING /* some of them are successfully
675: assigned */ THEN
676:
677: l_delivery_done := TRUE;
678: IF l_action_out_rec.result_id_tab.count > 0 THEN

Line 712: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR , WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN

708: p_message => substrb(l_exception_message,1,2000),
709: p_delivery_id => l_delivery_id,
710: p_delivery_detail_id => l_action_out_rec.result_id_tab(i));
711:
712: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR , WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
713: IF l_debug_on THEN
714: WSH_DEBUG_SV.log(l_module_name,' log_exception failed ');
715: END IF;
716: raise log_exception_err;

Line 803: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

799: WSH_XC_UTIL.LOG_OTM_EXCEPTION(
800: p_delivery_info_tab => l_delivery_info_tab,
801: p_new_interface_flag_tab => l_new_interface_flag_tab,
802: x_return_status => l_otm_return_status);
803: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
804: x_return_status := l_otm_return_status;
805: IF l_debug_on THEN
806: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
807: WSH_DEBUG_SV.pop(l_module_name);

Line 831: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

827: END IF;
828: i := l_cc_group_ids.next(i);
829: END LOOP;
830: END IF;
831: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
832: -- none of the delivery detail are assigned, it means that the delivery
833: -- do not match the constraint requirement, we have to try another delivery
834:
835: NULL;

Line 837: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

833: -- do not match the constraint requirement, we have to try another delivery
834:
835: NULL;
836:
837: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
838: -- searous error happens, skip to next sub-group
839:
840: i := p_line_rows.FIRST;
841: WHILE i is not NULL LOOP

Line 925: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

921: END IF;
922:
923:
924: IF x_unassigned_rows.count > 0 OR l_warning_num > 0 THEN
925: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
926: END IF;
927:
928: IF l_debug_on THEN
929: WSH_DEBUG_SV.pop(l_module_name, 'Return Status: '||x_return_status);

Line 943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

939: IF c_get_deliveries%ISOPEN THEN
940: CLOSE c_get_deliveries;
941: END IF;
942:
943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
944: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
945: IF l_debug_on THEN
946: WSH_DEBUG_SV.pop(l_module_name, 'Log_exception returns error ');
947: END IF;

Line 944: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

940: CLOSE c_get_deliveries;
941: END IF;
942:
943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
944: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
945: IF l_debug_on THEN
946: WSH_DEBUG_SV.pop(l_module_name, 'Log_exception returns error ');
947: END IF;
948:

Line 956: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');

952: -- if the cursor is still open then close the cursor
953: IF c_get_deliveries%ISOPEN THEN
954: CLOSE c_get_deliveries;
955: END IF;
956: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');
957: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
958: IF l_debug_on THEN
959: WSH_DEBUG_SV.pop(l_module_name);
960: END IF;

Line 957: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

953: IF c_get_deliveries%ISOPEN THEN
954: CLOSE c_get_deliveries;
955: END IF;
956: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');
957: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
958: IF l_debug_on THEN
959: WSH_DEBUG_SV.pop(l_module_name);
960: END IF;
961:

Line 1014: p_delivery_detail_tbl IN WSH_UTIL_CORE.Id_Tab_Type,

1010: --
1011: -- ----------------------------------------------------------------------------------
1012:
1013: PROCEDURE Append_to_Deliveries(
1014: p_delivery_detail_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
1015: p_append_flag IN VARCHAR2,
1016: p_group_by_header IN VARCHAR2,
1017: p_commit IN VARCHAR2,
1018: p_lock_rows IN VARCHAR2,

Line 1021: x_unappended_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

1017: p_commit IN VARCHAR2,
1018: p_lock_rows IN VARCHAR2,
1019: p_check_fte_compatibility IN VARCHAR2,
1020: x_appended_det_tbl OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
1021: x_unappended_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1022: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1023: x_return_status OUT NOCOPY VARCHAR2) IS
1024:
1025: CURSOR get_line_details_check(c_detail_id NUMBER) IS

Line 1022: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

1018: p_lock_rows IN VARCHAR2,
1019: p_check_fte_compatibility IN VARCHAR2,
1020: x_appended_det_tbl OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
1021: x_unappended_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1022: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1023: x_return_status OUT NOCOPY VARCHAR2) IS
1024:
1025: CURSOR get_line_details_check(c_detail_id NUMBER) IS
1026: SELECT wdd.delivery_detail_id,

Line 1067: l_unassigned_rows WSH_UTIL_CORE.Id_Tab_Type;

1063: l_return_status VARCHAR2(1) ;
1064:
1065: l_detail_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1066:
1067: l_unassigned_rows WSH_UTIL_CORE.Id_Tab_Type;
1068: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1069: l_index NUMBER;
1070: l_delivery_detail_id NUMBER;
1071:

Line 1075: l_matched_entities WSH_UTIL_CORE.id_tab_type;

1071:
1072: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1073: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1074: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1075: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1076: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1077:
1078: l_debug_on BOOLEAN;
1079: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'Append_to_Deliveries';

Line 1104: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1100: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);
1101:
1102: END IF;
1103:
1104: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1105: x_unappended_det_tbl.delete; -- unappended list
1106: x_appended_det_tbl.delete; -- successfully appended list
1107: x_appended_del_tbl.delete; -- appended deliveries
1108:

Line 1211: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1207: END LOOP;
1208:
1209: END IF;
1210:
1211: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1212: l_warning_num := l_warning_num + 1;
1213: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1214: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1215: raise Group_Delivery_Details_ERR;

Line 1213: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

1209: END IF;
1210:
1211: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1212: l_warning_num := l_warning_num + 1;
1213: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1214: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1215: raise Group_Delivery_Details_ERR;
1216: END IF;
1217:

Line 1214: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1210:
1211: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1212: l_warning_num := l_warning_num + 1;
1213: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1214: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1215: raise Group_Delivery_Details_ERR;
1216: END IF;
1217:
1218: IF l_debug_on THEN

Line 1236: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1232: IF l_debug_on THEN
1233: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from Auto_Assign_Deliveries: '|| l_return_status );
1234: END IF;
1235:
1236: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1237: l_warning_num := l_warning_num + 1;
1238: IF l_unassigned_rows.count > 0 THEN
1239: l_index := l_unassigned_rows.FIRST;
1240: WHILE l_index IS NOT NULL LOOP

Line 1248: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

1244: END IF;
1245: IF l_debug_on THEN
1246: WSH_DEBUG_SV.log(l_module_name,'x_unappended_det_tbl.count', x_unappended_det_tbl.count);
1247: END IF;
1248: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1249: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1250: raise Auto_Assign_Deliveries_ERR;
1251: END IF;
1252:

Line 1249: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1245: IF l_debug_on THEN
1246: WSH_DEBUG_SV.log(l_module_name,'x_unappended_det_tbl.count', x_unappended_det_tbl.count);
1247: END IF;
1248: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1249: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1250: raise Auto_Assign_Deliveries_ERR;
1251: END IF;
1252:
1253:

Line 1261: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1257:
1258: END IF;
1259:
1260: IF x_unappended_det_tbl.count > 0 OR l_warning_num > 0 THEN
1261: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1262: END IF;
1263:
1264: IF l_debug_on THEN
1265: wsh_debug_sv.pop(l_module_name);

Line 1272: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1268: EXCEPTION
1269:
1270: WHEN Group_Delivery_Details_ERR THEN
1271: ROLLBACK TO START_OF_APPEND_DELIVERIES;
1272: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1273: FND_MESSAGE.SET_NAME('WSH', 'WSH_GRP_DETAILS_ERR');
1274: wsh_util_core.add_message(x_return_status, l_module_name);
1275:
1276: IF l_debug_on THEN

Line 1274: wsh_util_core.add_message(x_return_status, l_module_name);

1270: WHEN Group_Delivery_Details_ERR THEN
1271: ROLLBACK TO START_OF_APPEND_DELIVERIES;
1272: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1273: FND_MESSAGE.SET_NAME('WSH', 'WSH_GRP_DETAILS_ERR');
1274: wsh_util_core.add_message(x_return_status, l_module_name);
1275:
1276: IF l_debug_on THEN
1277: wsh_debug_sv.logmsg(l_module_name, 'Group_Delivery_Details failed');
1278: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Group_Delivery_Details_ERR');

Line 1283: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1279: END IF;
1280:
1281: WHEN Auto_Assign_Deliveries_ERR THEN
1282: ROLLBACK TO START_OF_APPEND_DELIVERIES;
1283: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1284: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTO_ASSIGN_ERR');
1285: wsh_util_core.add_message(x_return_status, l_module_name);
1286:
1287: IF l_debug_on THEN

Line 1285: wsh_util_core.add_message(x_return_status, l_module_name);

1281: WHEN Auto_Assign_Deliveries_ERR THEN
1282: ROLLBACK TO START_OF_APPEND_DELIVERIES;
1283: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1284: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTO_ASSIGN_ERR');
1285: wsh_util_core.add_message(x_return_status, l_module_name);
1286:
1287: IF l_debug_on THEN
1288: wsh_debug_sv.logmsg(l_module_name, 'Auto_Assign_Deliveries failed');
1289: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Auto_Assign_Deliveries_ERR');

Line 1299: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 1300: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');

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

Line 1396: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1392: WSH_DEBUG_SV.log(l_module_name, 'p_changed_attributes.count',p_changed_attributes.count);
1393: WSH_DEBUG_SV.log(l_module_name, 'p_source_code', p_source_code);
1394: END IF;
1395: --
1396: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1397:
1398: IF not WSH_DELIVERY_UTIL.G_INBOUND_FLAG and
1399: p_source_code = 'OE' -- check with klr
1400: THEN

Line 1434: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1430: IF l_debug_on THEN
1431: wsh_debug_sv.log(l_module_name,'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
1432: END IF;
1433:
1434: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1435: raise wsh_invalid_org;
1436: END IF;
1437:
1438: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TW2' ) THEN

Line 1454: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1450: WSH_DEBUG_SV.log(l_module_name, 'Return Status of WSH_DELIVERY_DETAILS_PUB.Split_Line', l_return_status);
1451: END IF;
1452: --
1453:
1454: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1455: --
1456: IF l_debug_on THEN
1457: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: CMS changes other than Quantity and Quantity UOM');
1458: END IF;

Line 1549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1545: END IF;
1546: --
1547: EXCEPTION
1548: WHEN wsh_update_not_allowed THEN
1549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1550: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_NOT_ALLOWED');
1551: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
1552: x_update_allowed := 'N';
1553: IF c_del_details%ISOPEN THEN

Line 1551: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

1547: EXCEPTION
1548: WHEN wsh_update_not_allowed THEN
1549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1550: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_NOT_ALLOWED');
1551: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
1552: x_update_allowed := 'N';
1553: IF c_del_details%ISOPEN THEN
1554: close c_del_details;
1555: END IF;

Line 1563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_not_allowed');
1560: END IF;
1561: --
1562: WHEN wsh_invalid_org THEN
1563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1564: x_update_allowed := 'N';
1565: IF c_del_details%ISOPEN THEN
1566: close c_del_details;
1567: END IF;

Line 1575: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1571: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_org');
1572: END IF;
1573: --
1574: WHEN others THEN
1575: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1576: --
1577: IF l_debug_on THEN
1578: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
1579: END IF;

Line 1638: x_return_status := WSH_UTIl_CORE.G_RET_STS_SUCCESS;

1634: WSH_DEBUG_SV.push(l_module_name);
1635: END IF;
1636: --
1637:
1638: x_return_status := WSH_UTIl_CORE.G_RET_STS_SUCCESS;
1639:
1640: FOR i in p_changed_attributes.FIRST .. p_changed_attributes.LAST
1641: LOOP
1642: --

Line 2136: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2132: IF l_debug_on THEN
2133: WSH_DEBUG_SV.logmsg(l_module_name, 'INSIDE VALIDATION SUCCESS' );
2134: END IF;
2135: --
2136: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2137: ELSE
2138: --Raise Error
2139: --
2140: IF l_debug_on THEN

Line 2144: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2140: IF l_debug_on THEN
2141: WSH_DEBUG_SV.logmsg(l_module_name, 'Attributes does not match so returning error' );
2142: END IF;
2143: --
2144: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2145: END IF;
2146: END LOOP;
2147:
2148: --

Line 2156: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2152: END IF;
2153: --
2154: EXCEPTION
2155: WHEN OTHERS THEN
2156: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2157: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Delivery_Line');
2158: --
2159: IF l_debug_on THEN
2160: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2157: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Delivery_Line');

2153: --
2154: EXCEPTION
2155: WHEN OTHERS THEN
2156: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2157: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Delivery_Line');
2158: --
2159: IF l_debug_on THEN
2160: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2161: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');