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 37: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

33: p_line_rows IN OUT NOCOPY wsh_delivery_autocreate.grp_attr_tab_type,
34: p_group_by_header IN VARCHAR2,
35: p_check_fte_compatibility IN VARCHAR2,
36: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
37: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
38: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
39: x_return_status OUT NOCOPY VARCHAR2) IS
40:
41:

Line 38: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

34: p_group_by_header IN VARCHAR2,
35: p_check_fte_compatibility IN VARCHAR2,
36: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
37: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
38: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
39: x_return_status OUT NOCOPY VARCHAR2) IS
40:
41:
42:

Line 48: l_cc_in_ids WSH_UTIL_CORE.id_tab_type;

44: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
45: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
46: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
47: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
48: l_cc_in_ids WSH_UTIL_CORE.id_tab_type;
49: l_cc_fail_ids WSH_UTIL_CORE.id_tab_type;
50: l_cc_validate_result VARCHAR2(1);
51: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
52: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;

Line 49: l_cc_fail_ids WSH_UTIL_CORE.id_tab_type;

45: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
46: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
47: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
48: l_cc_in_ids WSH_UTIL_CORE.id_tab_type;
49: l_cc_fail_ids WSH_UTIL_CORE.id_tab_type;
50: l_cc_validate_result VARCHAR2(1);
51: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
52: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
53: l_cc_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;

Line 74: l_matched_entities WSH_UTIL_CORE.id_tab_type;

70: l_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
71: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
72: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
73: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
74: l_matched_entities WSH_UTIL_CORE.id_tab_type;
75: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
76:
77:
78: l_index NUMBER;

Line 84: l_cc_group_ids WSH_UTIL_CORE.id_tab_type;

80:
81: l_cc_groupExists BOOLEAN;
82: l_delivery_done BOOLEAN;
83: l_multiple_sub_groups BOOLEAN;
84: l_cc_group_ids WSH_UTIL_CORE.id_tab_type;
85:
86: l_get_autocreate_del_criteria VARCHAR2(1);
87: l_warning_num NUMBER := 0;
88: i NUMBER;

Line 137: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

133:
134: -- OTM R12 : update delivery
135: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
136: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
137: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
138: l_tms_update VARCHAR2(1);
139: l_trip_not_found VARCHAR2(1);
140: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
141: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;

Line 163: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

159: END IF;
160:
161:
162:
163: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
164: -- OTM R12
165: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
166:
167: IF (l_gc3_is_installed IS NULL) THEN

Line 165: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

161:
162:
163: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
164: -- OTM R12
165: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
166:
167: IF (l_gc3_is_installed IS NULL) THEN
168: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
169: END IF;

Line 168: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

164: -- OTM R12
165: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
166:
167: IF (l_gc3_is_installed IS NULL) THEN
168: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
169: END IF;
170: -- End of OTM R12
171:
172:

Line 217: IF wsh_util_core.fte_is_installed = 'Y'

213: l_cc_line_groups.delete;
214:
215:
216: -- construct
217: IF wsh_util_core.fte_is_installed = 'Y'
218: AND p_check_fte_compatibility = FND_API.G_TRUE
219: AND l_cc_in_ids.count > 1 THEN
220: IF l_debug_on THEN
221: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main');

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

246:
247: -- x_fail_ids and x_failed_lines are not populated for AUTOCREATE-DEL
248: l_cc_group_ids.delete;
249:
250: IF l_cc_line_groups.COUNT > 0 AND l_return_status = wsh_util_core.g_ret_sts_error THEN
251:
252: i := l_cc_line_groups.FIRST;
253: WHILE i is NOT NULL LOOP
254:

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

431: l_tms_update := 'N';
432: l_new_interface_flag_tab(1) := NULL;
433:
434: -- delivery update will be done only for SUCCESS, WARNING case
435: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
436: WSH_UTIL_CORE.G_RET_STS_WARNING) AND
437: l_gc3_is_installed = 'Y' AND
438: nvl(l_ignore_for_planning, 'N') = 'N') THEN
439: -- l_otm_return_status is used here not to change l_return_status

Line 436: WSH_UTIL_CORE.G_RET_STS_WARNING) AND

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

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

446: (p_delivery_id => l_delivery_id,
447: x_trip_info_rec => l_trip_info_rec,
448: x_return_status => l_otm_return_status);
449:
450: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
451: x_return_status := l_otm_return_status;
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
454: WSH_DEBUG_SV.pop(l_module_name);

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

468: p_delivery_id => l_delivery_id,
469: x_delivery_rec => l_delivery_info,
470: x_return_status => l_otm_return_status);
471:
472: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
473: x_return_status := l_otm_return_status;
474: IF l_debug_on THEN
475: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
476: WSH_DEBUG_SV.pop(l_module_name);

Line 523: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

519:
520: -- If there are some delivery details assigned to the delivery,
521: -- we populate the assigned table and delete it from the main table
522:
523: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
524:
525: IF l_debug_on THEN
526: i := l_action_out_rec.result_id_tab.FIRST;
527: WHILE i is not NULL LOOP

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

562: p_delivery_id => l_delivery_id,
563: p_delivery_detail_id => l_details_in_cc_group(i).delivery_detail_id);
564:
565:
566: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR , WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.log(l_module_name,' log_exception failed ');
569: END IF;
570: raise log_exception_err;

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

643: WSH_XC_UTIL.LOG_OTM_EXCEPTION(
644: p_delivery_info_tab => l_delivery_info_tab,
645: p_new_interface_flag_tab => l_new_interface_flag_tab,
646: x_return_status => l_otm_return_status);
647: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
648: x_return_status := l_otm_return_status;
649: IF l_debug_on THEN
650: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
651: WSH_DEBUG_SV.pop(l_module_name);

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

664: END IF;
665: i := l_cc_group_ids.next(i);
666: END LOOP;
667:
668: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING /* some of them are successfully
669: assigned */ THEN
670:
671: l_delivery_done := TRUE;
672: IF l_action_out_rec.result_id_tab.count > 0 THEN

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

702: p_message => substrb(l_exception_message,1,2000),
703: p_delivery_id => l_delivery_id,
704: p_delivery_detail_id => l_action_out_rec.result_id_tab(i));
705:
706: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR , WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
707: IF l_debug_on THEN
708: WSH_DEBUG_SV.log(l_module_name,' log_exception failed ');
709: END IF;
710: raise log_exception_err;

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

793: WSH_XC_UTIL.LOG_OTM_EXCEPTION(
794: p_delivery_info_tab => l_delivery_info_tab,
795: p_new_interface_flag_tab => l_new_interface_flag_tab,
796: x_return_status => l_otm_return_status);
797: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
798: x_return_status := l_otm_return_status;
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
801: WSH_DEBUG_SV.pop(l_module_name);

Line 825: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

821: END IF;
822: i := l_cc_group_ids.next(i);
823: END LOOP;
824: END IF;
825: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
826: -- none of the delivery detail are assigned, it means that the delivery
827: -- do not match the constraint requirement, we have to try another delivery
828:
829: NULL;

Line 831: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

827: -- do not match the constraint requirement, we have to try another delivery
828:
829: NULL;
830:
831: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
832: -- searous error happens, skip to next sub-group
833:
834: i := p_line_rows.FIRST;
835: WHILE i is not NULL LOOP

Line 919: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

915: END IF;
916:
917:
918: IF x_unassigned_rows.count > 0 OR l_warning_num > 0 THEN
919: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
920: END IF;
921:
922: IF l_debug_on THEN
923: WSH_DEBUG_SV.pop(l_module_name, 'Return Status: '||x_return_status);

Line 937: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

933: IF c_get_deliveries%ISOPEN THEN
934: CLOSE c_get_deliveries;
935: END IF;
936:
937: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
938: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
939: IF l_debug_on THEN
940: WSH_DEBUG_SV.pop(l_module_name, 'Log_exception returns error ');
941: END IF;

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

934: CLOSE c_get_deliveries;
935: END IF;
936:
937: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
938: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
939: IF l_debug_on THEN
940: WSH_DEBUG_SV.pop(l_module_name, 'Log_exception returns error ');
941: END IF;
942:

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

946: -- if the cursor is still open then close the cursor
947: IF c_get_deliveries%ISOPEN THEN
948: CLOSE c_get_deliveries;
949: END IF;
950: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');
951: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
952: IF l_debug_on THEN
953: WSH_DEBUG_SV.pop(l_module_name);
954: END IF;

Line 951: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

947: IF c_get_deliveries%ISOPEN THEN
948: CLOSE c_get_deliveries;
949: END IF;
950: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');
951: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
952: IF l_debug_on THEN
953: WSH_DEBUG_SV.pop(l_module_name);
954: END IF;
955:

Line 1008: p_delivery_detail_tbl IN WSH_UTIL_CORE.Id_Tab_Type,

1004: --
1005: -- ----------------------------------------------------------------------------------
1006:
1007: PROCEDURE Append_to_Deliveries(
1008: p_delivery_detail_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
1009: p_append_flag IN VARCHAR2,
1010: p_group_by_header IN VARCHAR2,
1011: p_commit IN VARCHAR2,
1012: p_lock_rows IN VARCHAR2,

Line 1015: x_unappended_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

1011: p_commit IN VARCHAR2,
1012: p_lock_rows IN VARCHAR2,
1013: p_check_fte_compatibility IN VARCHAR2,
1014: x_appended_det_tbl OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
1015: x_unappended_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1016: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1017: x_return_status OUT NOCOPY VARCHAR2) IS
1018:
1019: CURSOR get_line_details_check(c_detail_id NUMBER) IS

Line 1016: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

1012: p_lock_rows IN VARCHAR2,
1013: p_check_fte_compatibility IN VARCHAR2,
1014: x_appended_det_tbl OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
1015: x_unappended_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1016: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1017: x_return_status OUT NOCOPY VARCHAR2) IS
1018:
1019: CURSOR get_line_details_check(c_detail_id NUMBER) IS
1020: SELECT wdd.delivery_detail_id,

Line 1061: l_unassigned_rows WSH_UTIL_CORE.Id_Tab_Type;

1057: l_return_status VARCHAR2(1) ;
1058:
1059: l_detail_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1060:
1061: l_unassigned_rows WSH_UTIL_CORE.Id_Tab_Type;
1062: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1063: l_index NUMBER;
1064: l_delivery_detail_id NUMBER;
1065:

Line 1069: l_matched_entities WSH_UTIL_CORE.id_tab_type;

1065:
1066: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1067: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1068: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1069: l_matched_entities WSH_UTIL_CORE.id_tab_type;
1070: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1071:
1072: l_debug_on BOOLEAN;
1073: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'Append_to_Deliveries';

Line 1098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);
1095:
1096: END IF;
1097:
1098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1099: x_unappended_det_tbl.delete; -- unappended list
1100: x_appended_det_tbl.delete; -- successfully appended list
1101: x_appended_del_tbl.delete; -- appended deliveries
1102:

Line 1205: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1201: END LOOP;
1202:
1203: END IF;
1204:
1205: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1206: l_warning_num := l_warning_num + 1;
1207: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1208: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1209: raise Group_Delivery_Details_ERR;

Line 1207: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

1203: END IF;
1204:
1205: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1206: l_warning_num := l_warning_num + 1;
1207: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1208: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1209: raise Group_Delivery_Details_ERR;
1210: END IF;
1211:

Line 1208: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1204:
1205: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1206: l_warning_num := l_warning_num + 1;
1207: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1208: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1209: raise Group_Delivery_Details_ERR;
1210: END IF;
1211:
1212: IF l_debug_on THEN

Line 1230: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.logmsg(l_module_name,'Return status from Auto_Assign_Deliveries: '|| l_return_status );
1228: END IF;
1229:
1230: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1231: l_warning_num := l_warning_num + 1;
1232: IF l_unassigned_rows.count > 0 THEN
1233: l_index := l_unassigned_rows.FIRST;
1234: WHILE l_index IS NOT NULL LOOP

Line 1242: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

1238: END IF;
1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.log(l_module_name,'x_unappended_det_tbl.count', x_unappended_det_tbl.count);
1241: END IF;
1242: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1243: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1244: raise Auto_Assign_Deliveries_ERR;
1245: END IF;
1246:

Line 1243: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.log(l_module_name,'x_unappended_det_tbl.count', x_unappended_det_tbl.count);
1241: END IF;
1242: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
1243: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1244: raise Auto_Assign_Deliveries_ERR;
1245: END IF;
1246:
1247:

Line 1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1251:
1252: END IF;
1253:
1254: IF x_unappended_det_tbl.count > 0 OR l_warning_num > 0 THEN
1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1256: END IF;
1257:
1258: IF l_debug_on THEN
1259: wsh_debug_sv.pop(l_module_name);

Line 1266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1262: EXCEPTION
1263:
1264: WHEN Group_Delivery_Details_ERR THEN
1265: ROLLBACK TO START_OF_APPEND_DELIVERIES;
1266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1267: FND_MESSAGE.SET_NAME('WSH', 'WSH_GRP_DETAILS_ERR');
1268: wsh_util_core.add_message(x_return_status, l_module_name);
1269:
1270: IF l_debug_on THEN

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

1264: WHEN Group_Delivery_Details_ERR THEN
1265: ROLLBACK TO START_OF_APPEND_DELIVERIES;
1266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1267: FND_MESSAGE.SET_NAME('WSH', 'WSH_GRP_DETAILS_ERR');
1268: wsh_util_core.add_message(x_return_status, l_module_name);
1269:
1270: IF l_debug_on THEN
1271: wsh_debug_sv.logmsg(l_module_name, 'Group_Delivery_Details failed');
1272: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Group_Delivery_Details_ERR');

Line 1277: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1273: END IF;
1274:
1275: WHEN Auto_Assign_Deliveries_ERR THEN
1276: ROLLBACK TO START_OF_APPEND_DELIVERIES;
1277: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1278: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTO_ASSIGN_ERR');
1279: wsh_util_core.add_message(x_return_status, l_module_name);
1280:
1281: IF l_debug_on THEN

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

1275: WHEN Auto_Assign_Deliveries_ERR THEN
1276: ROLLBACK TO START_OF_APPEND_DELIVERIES;
1277: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1278: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTO_ASSIGN_ERR');
1279: wsh_util_core.add_message(x_return_status, l_module_name);
1280:
1281: IF l_debug_on THEN
1282: wsh_debug_sv.logmsg(l_module_name, 'Auto_Assign_Deliveries failed');
1283: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:Auto_Assign_Deliveries_ERR');

Line 1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1289: IF get_line_details_check%ISOPEN THEN
1290: CLOSE get_line_details_check;
1291: END IF;
1292:
1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1294: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
1295: IF l_debug_on THEN
1296: wsh_debug_sv.log(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM);
1297: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');

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

1290: CLOSE get_line_details_check;
1291: END IF;
1292:
1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1294: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
1295: IF l_debug_on THEN
1296: wsh_debug_sv.log(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM);
1297: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
1298: END IF;