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.21.12010000.2 2008/08/22 08:02:18 mvudugul ship $ */
3:
4:
5: --

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

2: /* $Header: WSHDDTHB.pls 120.21.12010000.2 2008/08/22 08:02:18 mvudugul 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 939: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS_BULK',l_module_name);

935: WSH_DEBUG_SV.logmsg(l_module_name, 'WHEN OTHERS IN CREATE_DELIVERY_DETAILS_BULK ' || SQLERRM );
936: END IF;
937: --
938: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
939: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS_BULK',l_module_name);
940: --
941: IF l_debug_on THEN
942: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
943: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1491: WSH_DEBUG_SV.logmsg(l_module_name, 'WHEN OTHERS IN CREATE_DD_FROM_OLD_BULK ' || SQLERRM );
1492: END IF;
1493: --
1494: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1495: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DD_FROM_OLD_BULK',l_module_name);
1496: --
1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1618: --
1619: EXCEPTION
1620: WHEN others THEN
1621: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1622: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIV_ASSIGNMENT_BULK',l_module_name);
1623:
1624: --
1625: IF l_debug_on THEN
1626: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1687: WSH_DELIVERY_DETAILS_PKG.create_dd_from_old_bulk

1683: END IF;
1684: --
1685: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1686: -- make call to Bulk api from here
1687: WSH_DELIVERY_DETAILS_PKG.create_dd_from_old_bulk
1688: ( p_delivery_detail_rec => p_delivery_detail_rec,
1689: p_delivery_detail_id => p_delivery_detail_id,
1690: p_num_of_rec => 1,
1691: x_dd_id_tab => l_dd_id_tab,

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

1719: WSH_DEBUG_SV.logmsg(l_module_name, 'WHEN OTHERS IN CREATE_NEW_DETAIL_FROM_OLD ' || SQLERRM );
1720: END IF;
1721: --
1722: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1723: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD',l_module_name);
1724: --
1725: IF l_debug_on THEN
1726: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1727: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

2074: --
2075: EXCEPTION
2076: WHEN others THEN
2077: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2078: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',l_module_name);
2079:
2080: -- close all cursors at exception
2081: IF (get_del_detail%ISOPEN) THEN
2082: CLOSE get_del_detail;

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

3118: close c_lock_delivery_detail;
3119: end if;
3120:
3121: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
3122: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS');
3123: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
3124: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
3125:
3126: --

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

4241:
4242: WHEN others THEN
4243: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4244: ROLLBACK TO s_before_update_dd;
4245: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',l_module_name);
4246:
4247: IF (c_get_delivery_info%ISOPEN) THEN
4248: CLOSE c_get_delivery_info;
4249: END IF;

Line 4339: WSH_DELIVERY_DETAILS_PKG.Create_Deliv_Assignment_Bulk

4335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Create_Deliv_assignment_Bulk with 1');
4336: END IF;
4337: -- from this API call Bulk api with value of 1
4338:
4339: WSH_DELIVERY_DETAILS_PKG.Create_Deliv_Assignment_Bulk
4340: (p_delivery_assignments_info => p_delivery_assignments_info,
4341: p_num_of_rec => 1,
4342: p_dd_id_tab => l_dd_id_tab,
4343: x_da_id_tab => l_da_id_tab,

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

4361: --
4362: EXCEPTION
4363: WHEN others THEN
4364: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4365: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',l_module_name);
4366:
4367: --
4368: IF l_debug_on THEN
4369: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

4450: --
4451: EXCEPTION
4452: WHEN others THEN
4453: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4454: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG_.DELETE_DELIVERY_ASSIGNMENTS',l_module_name);
4455:
4456: --
4457: IF l_debug_on THEN
4458: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

4552: --
4553: EXCEPTION
4554: WHEN others THEN
4555: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4556: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_ASSIGNMENTS',l_module_name);
4557:
4558: --
4559: IF l_debug_on THEN
4560: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

4670: END IF;
4671: --
4672: EXCEPTION
4673: WHEN others THEN
4674: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_ASSIGNMENTS',l_module_name);
4675: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4676: --
4677: IF l_debug_on THEN
4678: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

4820: WHEN OTHERS THEN
4821: --
4822: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4823: --
4824: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS_WRAPPER',l_module_name);
4825: --
4826: IF l_debug_on THEN
4827: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4828: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

5182: END IF;
5183: --
5184: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
5185: --
5186: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.Table_to_Record',l_module_name);
5187: --
5188: IF l_debug_on THEN
5189: 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');
5190: END IF;

Line 5288: END WSH_DELIVERY_DETAILS_PKG;

5284: RAISE;
5285:
5286: END LOCK_WDA_NO_COMPARE;
5287:
5288: END WSH_DELIVERY_DETAILS_PKG;
5289: