APPS.WSH_INTEGRATION dependencies on WSH_INTEGRATION

Line 1: PACKAGE BODY WSH_INTEGRATION as

1: PACKAGE BODY WSH_INTEGRATION as
2: /* $Header: WSHINTGB.pls 120.14 2011/03/23 10:52:11 ashimalh ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INTEGRATION';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INTEGRATION';

1: PACKAGE BODY WSH_INTEGRATION as
2: /* $Header: WSHINTGB.pls 120.14 2011/03/23 10:52:11 ashimalh ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INTEGRATION';
6:
7: -- Global variable holding transaction_id
8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
9: -- WMS is not calling the API WSH_INTEGRATION.Set_Inv_PC_Attributes to set trx ids.

Line 9: -- WMS is not calling the API WSH_INTEGRATION.Set_Inv_PC_Attributes to set trx ids.

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INTEGRATION';
6:
7: -- Global variable holding transaction_id
8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
9: -- WMS is not calling the API WSH_INTEGRATION.Set_Inv_PC_Attributes to set trx ids.
10: TYPE InvPCRecType IS RECORD
11: ( transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM,
12: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM);
13:

Line 1199: --IF (WSH_INTEGRATION.DBI_Installed = 'N' OR BUG#11852550

1195: --
1196: -- Check if DBI is installed, possible values are Y or N only
1197: -- If not installed, then do not proceed , return Success
1198: -- Also, atleast 1 record should be populated in the Input table
1199: --IF (WSH_INTEGRATION.DBI_Installed = 'N' OR BUG#11852550
1200: IF p_delivery_detail_id_tab.count < 1
1201: THEN
1202: IF l_debug_on THEN
1203: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);

Line 1203: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);

1199: --IF (WSH_INTEGRATION.DBI_Installed = 'N' OR BUG#11852550
1200: IF p_delivery_detail_id_tab.count < 1
1201: THEN
1202: IF l_debug_on THEN
1203: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1204: WSH_DEBUG_SV.pop(l_module_name);
1205: END IF;
1206: RETURN;
1207: END IF;

Line 1312: --IF (WSH_INTEGRATION.DBI_Installed = 'N' OR BUG#11852550

1308: --
1309: -- Check if DBI is installed, possible values are Y or N only
1310: -- If not installed, then do not proceed , return Success
1311: -- Also, atleast 1 record should be populated in the Input table
1312: --IF (WSH_INTEGRATION.DBI_Installed = 'N' OR BUG#11852550
1313: IF p_stop_id_tab.count < 1
1314: THEN
1315: IF l_debug_on THEN
1316: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);

Line 1316: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);

1312: --IF (WSH_INTEGRATION.DBI_Installed = 'N' OR BUG#11852550
1313: IF p_stop_id_tab.count < 1
1314: THEN
1315: IF l_debug_on THEN
1316: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1317: WSH_DEBUG_SV.pop(l_module_name);
1318: END IF;
1319: RETURN;
1320: END IF;

Line 1603: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);

1599:
1600: EXCEPTION
1601: WHEN OTHERS THEN
1602: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1603: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1606: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1791: x_rec_tab OUT NOCOPY WSH_INTEGRATION.detail_lpn_rec_type_tab_type,

1787:
1788:
1789: PROCEDURE Get_Delivery_Detail_attributes ( p_header_id IN NUMBER,
1790: p_line_id IN NUMBER,
1791: x_rec_tab OUT NOCOPY WSH_INTEGRATION.detail_lpn_rec_type_tab_type,
1792: x_return_status OUT NOCOPY VARCHAR2)IS
1793:
1794: l_debug_on BOOLEAN;
1795: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'|| G_PKG_NAME || '.'|| ' Get_Delivery_Detail_attributes';

Line 2148: END WSH_INTEGRATION;

2144: --
2145: END Update_Delivery_Details;
2146: --RTV changes
2147:
2148: END WSH_INTEGRATION;