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_AUTOCREATE dependencies on WSH_DELIVERY_AUTOCREATE

Line 1: PACKAGE BODY WSH_DELIVERY_AUTOCREATE as

1: PACKAGE BODY WSH_DELIVERY_AUTOCREATE as
2: /* $Header: WSHDEAUB.pls 120.32 2011/09/05 09:00:44 shtadepa ship $ */
3:
4: g_hash_base NUMBER := 1;
5: g_hash_size NUMBER := power(2, 25);

Line 8: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_AUTOCREATE';

4: g_hash_base NUMBER := 1;
5: g_hash_size NUMBER := power(2, 25);
6:
7:
8: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_AUTOCREATE';
9: -----------------------------------------------------------------------------
10: --
11: -- Procedure: Get_Group_By_Attr
12: -- Parameters: p_organization_id, x_group_by_flags, x_return_status

Line 217: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR');

213: IF l_debug_on THEN
214: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM GET_GROUP_BY_ATTR IS ' || L_ERROR_TEXT );
215: END IF;
216: --
217: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR');
218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
219:
220: --
221: -- Debug Statements

Line 647: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Hash');

643:
644: EXCEPTION
645:
646: WHEN Others THEN
647: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Hash');
648: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
649: --
650: -- Debug Statements
651: --

Line 747: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Update_Hash');

743: END IF;
744: --
745:
746: WHEN Others THEN
747: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Update_Hash');
748: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
749: --
750: -- Debug Statements
751: --

Line 1038: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Groups');

1034: END IF;
1035: --
1036:
1037: WHEN Others THEN
1038: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Groups');
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1040: --
1041: -- Debug Statements
1042: --

Line 1744: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups');

1740: END IF;
1741: --
1742:
1743: WHEN Others THEN
1744: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups');
1745: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1746:
1747: IF c_matching_deliveries%ISOPEN THEN
1748: CLOSE c_matching_deliveries;

Line 1964: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTONOMOUS_CREATE_DELIVERY');

1960: END IF;
1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTONOMOUS_CREATE_DELIVERY');
1965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1966: IF l_debug_on THEN
1967: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1968: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2066: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

2062: -- bug 2691385
2063: l_detail_is_empty_cont VARCHAR2(1) := 'N';
2064: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
2065:
2066: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2067: l_action_rec wsh_delivery_autocreate.action_rec_type;
2068: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2069: l_matched_entities wsh_util_core.id_tab_type;
2070: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 2067: l_action_rec wsh_delivery_autocreate.action_rec_type;

2063: l_detail_is_empty_cont VARCHAR2(1) := 'N';
2064: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
2065:
2066: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2067: l_action_rec wsh_delivery_autocreate.action_rec_type;
2068: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2069: l_matched_entities wsh_util_core.id_tab_type;
2070: l_out_rec wsh_delivery_autocreate.out_rec_type;
2071: l_del_select_carrier wsh_util_core.id_tab_type;

Line 2068: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

2064: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
2065:
2066: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2067: l_action_rec wsh_delivery_autocreate.action_rec_type;
2068: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2069: l_matched_entities wsh_util_core.id_tab_type;
2070: l_out_rec wsh_delivery_autocreate.out_rec_type;
2071: l_del_select_carrier wsh_util_core.id_tab_type;
2072: l_del_rate wsh_util_core.id_tab_type;

Line 2070: l_out_rec wsh_delivery_autocreate.out_rec_type;

2066: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2067: l_action_rec wsh_delivery_autocreate.action_rec_type;
2068: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2069: l_matched_entities wsh_util_core.id_tab_type;
2070: l_out_rec wsh_delivery_autocreate.out_rec_type;
2071: l_del_select_carrier wsh_util_core.id_tab_type;
2072: l_del_rate wsh_util_core.id_tab_type;
2073: l_del_rate_location wsh_util_core.id_tab_type;
2074:

Line 2416: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_AUTOCREATE.Autonomous_Create_Delivery RETURNED ERROR');

2412: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2413: raise others;
2414: ELSE
2415: IF l_debug_on THEN
2416: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_AUTOCREATE.Autonomous_Create_Delivery RETURNED ERROR');
2417: END IF;
2418: raise e_return_excp;
2419: END IF;
2420: ELSE

Line 2835: WSH_DEBUG_SV.log(l_module_name, 'Return status from WSH_DELIVERY_AUTOCREATE.autocreate_deliveries', x_return_status);

2831: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2832: END IF;
2833:
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.log(l_module_name, 'Return status from WSH_DELIVERY_AUTOCREATE.autocreate_deliveries', x_return_status);
2836: WSH_DEBUG_SV.pop(l_module_name);
2837: END IF;
2838: --
2839:

Line 2969: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES IS ' || L_ERROR_TEXT );

2965: --
2966: -- LPN CONV. rv
2967: --
2968: IF l_debug_on THEN
2969: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES IS ' || L_ERROR_TEXT );
2970: END IF;
2971: --
2972: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES');
2973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2972: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES');

2968: IF l_debug_on THEN
2969: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES IS ' || L_ERROR_TEXT );
2970: END IF;
2971: --
2972: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES');
2973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2974:
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.pop(l_module_name);

Line 2992: -- - WSH_DELIVERY_AUTOCREATE.autocreate_del_across_orgs

2988: -- p_org_rows - a table of organization_ids. If this
2989: -- - table is not available to pass
2990: -- - then pass a dummy value in. the table
2991: -- - will get regenerated when calling
2992: -- - WSH_DELIVERY_AUTOCREATE.autocreate_del_across_orgs
2993: -- p_container_flag - 'Y' means call Autopack routine
2994: -- p_check_flag - 'Y' means delivery details will be
2995: -- grouped without creating deliveries
2996: -- p_max_detail_commit - Commits data after delivery detail

Line 3335: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS');

3331: --
3332: EXCEPTION
3333: WHEN Others THEN
3334:
3335: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS');
3336: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3337: --
3338: -- Debug Statements
3339: --

Line 3446: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.DELETE_EMPTY_DELIVERIES');

3442: END IF;
3443: --
3444: EXCEPTION
3445: WHEN OTHERS THEN
3446: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.DELETE_EMPTY_DELIVERIES');
3447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3448: --
3449: -- Debug Statements
3450: --

Line 4044: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.unassign_empty_containers');

4040: END IF;
4041: --
4042: -- LPN CONV. rv
4043: --
4044: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.unassign_empty_containers');
4045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4046: --
4047: -- Debug Statements
4048: --

Line 4607: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.Autocreate_Consol_Delivery',l_module_name);

4603: END IF;
4604: --
4605:
4606: WHEN OTHERS THEN
4607: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.Autocreate_Consol_Delivery',l_module_name);
4608: --
4609: IF l_debug_on THEN
4610: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
4611: END IF;

Line 4615: END WSH_DELIVERY_AUTOCREATE;

4611: END IF;
4612:
4613: END Autocreate_Consol_Delivery;
4614:
4615: END WSH_DELIVERY_AUTOCREATE;
4616: