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.26.12010000.2 2008/08/21 15:44:56 gbhargav 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 168: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR');

164: IF l_debug_on THEN
165: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM GET_GROUP_BY_ATTR IS ' || L_ERROR_TEXT );
166: END IF;
167: --
168: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR');
169: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
170:
171: --
172: -- Debug Statements

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

573:
574: EXCEPTION
575:
576: WHEN Others THEN
577: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Hash');
578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
579: --
580: -- Debug Statements
581: --

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

669: END IF;
670: --
671:
672: WHEN Others THEN
673: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Update_Hash');
674: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
675: --
676: -- Debug Statements
677: --

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

956: END IF;
957: --
958:
959: WHEN Others THEN
960: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Groups');
961: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
962: --
963: -- Debug Statements
964: --

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

1510: END IF;
1511: --
1512:
1513: WHEN Others THEN
1514: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups');
1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1516:
1517: IF c_matching_deliveries%ISOPEN THEN
1518: CLOSE c_matching_deliveries;

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

1730: END IF;
1731:
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTONOMOUS_CREATE_DELIVERY');
1735: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1736: IF l_debug_on THEN
1737: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1738: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1836: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

1832: -- bug 2691385
1833: l_detail_is_empty_cont VARCHAR2(1) := 'N';
1834: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1835:
1836: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1837: l_action_rec wsh_delivery_autocreate.action_rec_type;
1838: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1839: l_matched_entities wsh_util_core.id_tab_type;
1840: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 1837: l_action_rec wsh_delivery_autocreate.action_rec_type;

1833: l_detail_is_empty_cont VARCHAR2(1) := 'N';
1834: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1835:
1836: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1837: l_action_rec wsh_delivery_autocreate.action_rec_type;
1838: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1839: l_matched_entities wsh_util_core.id_tab_type;
1840: l_out_rec wsh_delivery_autocreate.out_rec_type;
1841: l_del_select_carrier wsh_util_core.id_tab_type;

Line 1838: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

1834: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1835:
1836: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1837: l_action_rec wsh_delivery_autocreate.action_rec_type;
1838: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1839: l_matched_entities wsh_util_core.id_tab_type;
1840: l_out_rec wsh_delivery_autocreate.out_rec_type;
1841: l_del_select_carrier wsh_util_core.id_tab_type;
1842: l_del_rate wsh_util_core.id_tab_type;

Line 1840: l_out_rec wsh_delivery_autocreate.out_rec_type;

1836: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1837: l_action_rec wsh_delivery_autocreate.action_rec_type;
1838: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1839: l_matched_entities wsh_util_core.id_tab_type;
1840: l_out_rec wsh_delivery_autocreate.out_rec_type;
1841: l_del_select_carrier wsh_util_core.id_tab_type;
1842: l_del_rate wsh_util_core.id_tab_type;
1843: l_del_rate_location wsh_util_core.id_tab_type;
1844:

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

2162: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2163: raise others;
2164: ELSE
2165: IF l_debug_on THEN
2166: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_AUTOCREATE.Autonomous_Create_Delivery RETURNED ERROR');
2167: END IF;
2168: raise e_return_excp;
2169: END IF;
2170: ELSE

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

2581: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2582: END IF;
2583:
2584: IF l_debug_on THEN
2585: WSH_DEBUG_SV.log(l_module_name, 'Return status from WSH_DELIVERY_AUTOCREATE.autocreate_deliveries', x_return_status);
2586: WSH_DEBUG_SV.pop(l_module_name);
2587: END IF;
2588: --
2589:

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

2715: --
2716: -- LPN CONV. rv
2717: --
2718: IF l_debug_on THEN
2719: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES IS ' || L_ERROR_TEXT );
2720: END IF;
2721: --
2722: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES');
2723: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

2718: IF l_debug_on THEN
2719: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES IS ' || L_ERROR_TEXT );
2720: END IF;
2721: --
2722: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES');
2723: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2724:
2725: IF l_debug_on THEN
2726: WSH_DEBUG_SV.pop(l_module_name);

Line 2742: -- - WSH_DELIVERY_AUTOCREATE.autocreate_del_across_orgs

2738: -- p_org_rows - a table of organization_ids. If this
2739: -- - table is not available to pass
2740: -- - then pass a dummy value in. the table
2741: -- - will get regenerated when calling
2742: -- - WSH_DELIVERY_AUTOCREATE.autocreate_del_across_orgs
2743: -- p_container_flag - 'Y' means call Autopack routine
2744: -- p_check_flag - 'Y' means delivery details will be
2745: -- grouped without creating deliveries
2746: -- p_max_detail_commit - Commits data after delivery detail

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

3073: --
3074: EXCEPTION
3075: WHEN Others THEN
3076:
3077: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS');
3078: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3079: --
3080: -- Debug Statements
3081: --

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

3184: END IF;
3185: --
3186: EXCEPTION
3187: WHEN OTHERS THEN
3188: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.DELETE_EMPTY_DELIVERIES');
3189: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3190: --
3191: -- Debug Statements
3192: --

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

3781: END IF;
3782: --
3783: -- LPN CONV. rv
3784: --
3785: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.unassign_empty_containers');
3786: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3787: --
3788: -- Debug Statements
3789: --

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

4344: END IF;
4345: --
4346:
4347: WHEN OTHERS THEN
4348: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.Autocreate_Consol_Delivery',l_module_name);
4349: --
4350: IF l_debug_on THEN
4351: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
4352: END IF;

Line 4356: END WSH_DELIVERY_AUTOCREATE;

4352: END IF;
4353:
4354: END Autocreate_Consol_Delivery;
4355:
4356: END WSH_DELIVERY_AUTOCREATE;
4357: