187: l_cont_ins_id NUMBER := NULL;
188: l_tabofdeldets wsh_util_core.id_tab_type;
189: l_msg_summary VARCHAR2(2000) := NULL;
190: l_msg_details VARCHAR2(4000) := NULL;
191: l_del_params wsh_delivery_autocreate.grp_attr_tab_type;
192: wsh_no_del_det_tbl EXCEPTION;
193: wsh_no_delivery_id EXCEPTION;
194: wsh_no_delivery EXCEPTION; /*2777869*/
195: wsh_invalid_delivery_id EXCEPTION; /*2777869*/
1673: END IF;
1674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1675:
1676: IF l_debug_on THEN
1677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS',WSH_DEBUG_SV.C_PROC_LEVEL);
1678: END IF;
1679: --
1680: wsh_delivery_autocreate.autocreate_del_across_orgs(
1681: p_line_rows => p_line_rows,
1676: IF l_debug_on THEN
1677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS',WSH_DEBUG_SV.C_PROC_LEVEL);
1678: END IF;
1679: --
1680: wsh_delivery_autocreate.autocreate_del_across_orgs(
1681: p_line_rows => p_line_rows,
1682: p_org_rows => l_dummy_rows, -- bug 1668578
1683: p_container_flag => 'N',
1684: p_check_flag => 'N',
2311: --
2312: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
2313: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
2314: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2313: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
2314: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2314: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2323:
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2323:
2324: -- Consolidation of BO Delivery details project
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2323:
2324: -- Consolidation of BO Delivery details project
2325: l_line_ids WSH_UTIL_CORE.Id_Tab_Type;
2326: l_cons_flags WSH_UTIL_CORE.Column_Tab_Type;
3113: l_action_rec.output_format_type := 'TEMP_TAB';
3114: l_action_rec.action := 'MATCH_GROUPS';
3115:
3116:
3117: wsh_delivery_autocreate.Find_Matching_Groups(
3118: p_attr_tab => l_attr_tab,
3119: p_action_rec => l_action_rec,
3120: p_target_rec => l_target_rec,
3121: p_group_tab => l_group_info,
10756: PROCEDURE Get_Carton_Grouping (p_line_rows IN WSH_UTIL_CORE.id_tab_type,
10757: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
10758: x_return_status OUT NOCOPY VARCHAR2) IS
10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10757: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
10758: x_return_status OUT NOCOPY VARCHAR2) IS
10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10765: l_out_rec wsh_delivery_autocreate.out_rec_type;
10758: x_return_status OUT NOCOPY VARCHAR2) IS
10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10765: l_out_rec wsh_delivery_autocreate.out_rec_type;
10766:
10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10765: l_out_rec wsh_delivery_autocreate.out_rec_type;
10766:
10767: l_debug_on Boolean;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10765: l_out_rec wsh_delivery_autocreate.out_rec_type;
10766:
10767: l_debug_on Boolean;
10768:
10769: --bug 7171766
10795: END LOOP;
10796: l_action_rec.action := 'MATCH_GROUPS';
10797:
10798: IF l_debug_on THEN
10799: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups', WSH_DEBUG_SV.C_PROC_LEVEL);
10800: END IF;
10801: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups (
10802: p_attr_tab => l_attr_tab,
10803: p_action_rec => l_action_rec,
10797:
10798: IF l_debug_on THEN
10799: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups', WSH_DEBUG_SV.C_PROC_LEVEL);
10800: END IF;
10801: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups (
10802: p_attr_tab => l_attr_tab,
10803: p_action_rec => l_action_rec,
10804: p_target_rec => l_target_rec,
10805: p_group_tab => l_group_tab,