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_PKG dependencies on WSH_DELIVERY_DETAILS_PKG

Line 1: PACKAGE BODY WSH_DELIVERY_DETAILS_PKG as

1: PACKAGE BODY WSH_DELIVERY_DETAILS_PKG as
2: /* $Header: WSHDDTHB.pls 120.32 2011/05/20 12:39:26 ashimalh ship $ */
3:
4:
5: --

Line 6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_PKG';

2: /* $Header: WSHDDTHB.pls 120.32 2011/05/20 12:39:26 ashimalh ship $ */
3:
4:
5: --
6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_PKG';
7: --
8: --
9: -- Procedure: Create_Delivery_Details
10: -- Parameters: All Attributes of a Delivery Detail Record,

Line 111: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Details_Bulk

107: l_container_info_rec.lpn_ids(1) := p_delivery_details_info.lpn_id;
108: l_container_info_rec.container_names(1) :=
109: p_delivery_details_info.container_name;
110:
111: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Details_Bulk
112: (p_delivery_details_info => p_delivery_details_info,
113: p_num_of_rec => 1,
114: -- lpn conv
115: p_container_info_rec => l_container_info_rec,

Line 144: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS',l_module_name);

140: EXCEPTION
141: WHEN others THEN
142: --
143: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
144: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS',l_module_name);
145: --
146: IF l_debug_on THEN
147: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
148: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 973: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS_BULK',l_module_name);

969: WSH_DEBUG_SV.logmsg(l_module_name, 'WHEN OTHERS IN CREATE_DELIVERY_DETAILS_BULK ' || SQLERRM );
970: END IF;
971: --
972: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
973: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS_BULK',l_module_name);
974: --
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
977: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1632: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DD_FROM_OLD_BULK',l_module_name);

1628: WSH_DEBUG_SV.logmsg(l_module_name, 'WHEN OTHERS IN CREATE_DD_FROM_OLD_BULK ' || SQLERRM );
1629: END IF;
1630: --
1631: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1632: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DD_FROM_OLD_BULK',l_module_name);
1633: --
1634: IF l_debug_on THEN
1635: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1759: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIV_ASSIGNMENT_BULK',l_module_name);

1755: --
1756: EXCEPTION
1757: WHEN others THEN
1758: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1759: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIV_ASSIGNMENT_BULK',l_module_name);
1760:
1761: --
1762: IF l_debug_on THEN
1763: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1824: WSH_DELIVERY_DETAILS_PKG.create_dd_from_old_bulk

1820: END IF;
1821: --
1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1823: -- make call to Bulk api from here
1824: WSH_DELIVERY_DETAILS_PKG.create_dd_from_old_bulk
1825: ( p_delivery_detail_rec => p_delivery_detail_rec,
1826: p_delivery_detail_id => p_delivery_detail_id,
1827: p_num_of_rec => 1,
1828: x_dd_id_tab => l_dd_id_tab,

Line 1860: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD',l_module_name);

1856: WSH_DEBUG_SV.logmsg(l_module_name, 'WHEN OTHERS IN CREATE_NEW_DETAIL_FROM_OLD ' || SQLERRM );
1857: END IF;
1858: --
1859: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1860: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD',l_module_name);
1861: --
1862: IF l_debug_on THEN
1863: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1864: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2213: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',l_module_name);

2209: --
2210: EXCEPTION
2211: WHEN others THEN
2212: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2213: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',l_module_name);
2214:
2215: -- close all cursors at exception
2216: IF (get_del_detail%ISOPEN) THEN
2217: CLOSE get_del_detail;

Line 3257: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');

3253: close c_lock_delivery_detail;
3254: end if;
3255:
3256: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3257: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3258: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3259: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3260:
3261: --

Line 4380: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',l_module_name);

4376:
4377: WHEN others THEN
4378: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4379: ROLLBACK TO s_before_update_dd;
4380: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',l_module_name);
4381:
4382: IF (c_get_delivery_info%ISOPEN) THEN
4383: CLOSE c_get_delivery_info;
4384: END IF;

Line 4474: WSH_DELIVERY_DETAILS_PKG.Create_Deliv_Assignment_Bulk

4470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Create_Deliv_assignment_Bulk with 1');
4471: END IF;
4472: -- from this API call Bulk api with value of 1
4473:
4474: WSH_DELIVERY_DETAILS_PKG.Create_Deliv_Assignment_Bulk
4475: (p_delivery_assignments_info => p_delivery_assignments_info,
4476: p_num_of_rec => 1,
4477: p_dd_id_tab => l_dd_id_tab,
4478: x_da_id_tab => l_da_id_tab,

Line 4500: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',l_module_name);

4496: --
4497: EXCEPTION
4498: WHEN others THEN
4499: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4500: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',l_module_name);
4501:
4502: --
4503: IF l_debug_on THEN
4504: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4589: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG_.DELETE_DELIVERY_ASSIGNMENTS',l_module_name);

4585: --
4586: EXCEPTION
4587: WHEN others THEN
4588: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4589: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG_.DELETE_DELIVERY_ASSIGNMENTS',l_module_name);
4590:
4591: --
4592: IF l_debug_on THEN
4593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4691: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_ASSIGNMENTS',l_module_name);

4687: --
4688: EXCEPTION
4689: WHEN others THEN
4690: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4691: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_ASSIGNMENTS',l_module_name);
4692:
4693: --
4694: IF l_debug_on THEN
4695: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4809: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_ASSIGNMENTS',l_module_name);

4805: END IF;
4806: --
4807: EXCEPTION
4808: WHEN others THEN
4809: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_ASSIGNMENTS',l_module_name);
4810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4811: --
4812: IF l_debug_on THEN
4813: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4959: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS_WRAPPER',l_module_name);

4955: WHEN OTHERS THEN
4956: --
4957: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4958: --
4959: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS_WRAPPER',l_module_name);
4960: --
4961: IF l_debug_on THEN
4962: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5338: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.Table_to_Record',l_module_name);

5334: END IF;
5335: --
5336: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
5337: --
5338: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.Table_to_Record',l_module_name);
5339: --
5340: IF l_debug_on THEN
5341: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL); WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5342: END IF;

Line 5440: END WSH_DELIVERY_DETAILS_PKG;

5436: RAISE;
5437:
5438: END LOCK_WDA_NO_COMPARE;
5439:
5440: END WSH_DELIVERY_DETAILS_PKG;
5441: