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_SHIPPING_PARAMS_PVT dependencies on WSH_UTIL_CORE

Line 20: C_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_ERROR;

16: g_parameters Parameter_Rec_Tab_Typ;
17: g_global_parameters Global_Parameters_rec_Tab_Typ;
18: g_parameter_values parameter_values_tbl;
19:
20: C_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_ERROR;
21: C_WARNING_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_WARNING;
22: C_SUCCESS_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
23: C_UNEXP_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
24:

Line 21: C_WARNING_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_WARNING;

17: g_global_parameters Global_Parameters_rec_Tab_Typ;
18: g_parameter_values parameter_values_tbl;
19:
20: C_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_ERROR;
21: C_WARNING_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_WARNING;
22: C_SUCCESS_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
23: C_UNEXP_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
24:
25: --

Line 22: C_SUCCESS_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

18: g_parameter_values parameter_values_tbl;
19:
20: C_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_ERROR;
21: C_WARNING_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_WARNING;
22: C_SUCCESS_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
23: C_UNEXP_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
24:
25: --
26: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_SHIPPING_PARAMS_PVT';

Line 23: C_UNEXP_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

19:
20: C_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_ERROR;
21: C_WARNING_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_WARNING;
22: C_SUCCESS_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
23: C_UNEXP_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
24:
25: --
26: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_SHIPPING_PARAMS_PVT';
27: --

Line 210: FND_MESSAGE.Set_Token('ORG_NAME', wsh_util_core.get_org_name(p_organization_id));

206: IF c_get_param%NOTFOUND THEN
207: --{
208: --Bug 3539616 : Error message shown when Shipping Parameters are not defined
209: FND_MESSAGE.Set_Name('WSH', 'WSH_SHP_NOT_FOUND');
210: FND_MESSAGE.Set_Token('ORG_NAME', wsh_util_core.get_org_name(p_organization_id));
211: FND_MSG_PUB.Add; --BUG#12599249
212: IF l_debug_on THEN
213: WSH_DEBUG_SV.log(l_module_name,'ERROR: ','Shipping Parameters not defined for Organization '||p_organization_id);
214: END IF;

Line 245: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

241: inv_cache.get_client_default_parameters (
242: p_client_id => p_client_id,
243: x_client_parameters_rec => l_client_params,
244: x_return_status => x_return_status);
245: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
246: IF l_debug_on THEN
247: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in get_client_default_parameters => ' || x_return_status, WSH_DEBUG_SV.C_ERR_LEVEL);
248: END IF;
249: RAISE NO_DATA_FOUND;

Line 739: l_parameter_name wsh_util_core.column_tab_type;

735: where organization_id = p_organization_id ;
736:
737: type l_varchar2_tbl is table of wsh_shipping_parameter_values.param_value%TYPE index by binary_integer;
738: l_param_value l_varchar2_tbl;
739: l_parameter_name wsh_util_core.column_tab_type;
740: l_param_value_info parameter_value_rec_typ;
741: temp_param_value_info parameter_value_rec_typ;
742: l_selective boolean;
743: l_row_count number;

Line 752: x_return_status := wsh_util_core.g_ret_sts_success;

748: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET ';
749:
750:
751: Begin
752: x_return_status := wsh_util_core.g_ret_sts_success;
753:
754: If x_param_value_info.param_name.count > 0 then
755: l_selective := TRUE;
756: l_parameter_name := x_param_value_info.param_name;

Line 876: x_return_status := wsh_util_core.g_ret_sts_error;

872: End If;
873:
874: Exception
875: When others then
876: x_return_status := wsh_util_core.g_ret_sts_error;
877: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
878: fnd_message.set_token('PACKAGE',l_module_name);
879: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
880: fnd_message.set_token('ORA_TEXT',SQLERRM);

Line 939: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_ship_par_rec.organization_id);

935: l_login_id number:= fnd_global.login_id;
936: l_debug_on boolean;
937: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_PARAMETER';
938: l_return_status varchar2(1);
939: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_ship_par_rec.organization_id);
940: handle_exception exception;
941: l_freight_count number;
942: l_param_count number ;
943: l_sqlerrm varchar2(2000);

Line 946: x_return_status := wsh_util_core.g_ret_sts_success;

942: l_param_count number ;
943: l_sqlerrm varchar2(2000);
944:
945: Begin
946: x_return_status := wsh_util_core.g_ret_sts_success;
947: l_debug_on := wsh_debug_interface.g_debug;
948: If l_debug_on is null then
949: l_debug_on := wsh_debug_sv.is_debug_enabled;
950: End If;

Line 1213: If l_return_status <> wsh_util_core.g_ret_sts_success then

1209:
1210: l_freight_terms_rec.organization_id := p_ship_par_val_rec.organization_id;
1211: create_freight_terms(l_freight_terms_rec
1212: ,l_return_status);
1213: If l_return_status <> wsh_util_core.g_ret_sts_success then
1214: If l_debug_on then
1215: wsh_debug_sv.log(l_module_name,'After call to create_freight_terms procedure l_return_status = ',l_return_status);
1216: End If;
1217: raise handle_exception;

Line 1288: x_return_status := wsh_util_core.g_ret_sts_error;

1284: End If;
1285:
1286: Exception
1287: When handle_exception then
1288: x_return_status := wsh_util_core.g_ret_sts_error;
1289: If l_debug_on then
1290: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1291: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);
1292: wsh_debug_sv.pop(l_module_name);

Line 1296: x_return_status := wsh_util_core.g_ret_sts_error;

1292: wsh_debug_sv.pop(l_module_name);
1293: End If;
1294:
1295: When others then
1296: x_return_status := wsh_util_core.g_ret_sts_error;
1297: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1298: fnd_message.set_token('PACKAGE',l_module_name);
1299: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1300: fnd_message.set_token('ORA_TEXT',SQLERRM);

Line 1345: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_ship_par_rec.organization_id);

1341: l_record_exists boolean := FALSE;
1342: ins_count number;
1343: upd_count number;
1344: l_debug_on boolean;
1345: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_ship_par_rec.organization_id);
1346: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_PARAMETER';
1347: l_freight_count number ;
1348: l_return_status varchar2(10);
1349: l_freight_terms varchar2(240);

Line 1371: x_return_status := wsh_util_core.g_ret_sts_success;

1367: handle_exception exception;
1368:
1369:
1370: Begin
1371: x_return_status := wsh_util_core.g_ret_sts_success;
1372: l_debug_on := wsh_debug_interface.g_debug;
1373: If l_debug_on is null then
1374: l_debug_on := wsh_debug_sv.is_debug_enabled;
1375: End If;

Line 1588: If l_return_status <> wsh_util_core.g_ret_sts_success then

1584: raise handle_exception;
1585: End;
1586: create_freight_terms(l_freight_terms_rec
1587: ,l_return_status);
1588: If l_return_status <> wsh_util_core.g_ret_sts_success then
1589: If l_debug_on then
1590: wsh_debug_sv.log(l_module_name,'After call to create_freight_terms procedure l_return_status = ',l_return_status);
1591: End If;
1592: raise handle_exception;

Line 1692: x_return_status := wsh_util_core.g_ret_sts_error;

1688: If l_debug_on then
1689: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1690: wsh_debug_sv.pop(l_module_name);
1691: End If;
1692: x_return_status := wsh_util_core.g_ret_sts_error;
1693:
1694: When others then
1695: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1696: fnd_message.set_token('PACKAGE',l_module_name);

Line 1703: x_return_status := wsh_util_core.g_ret_sts_error;

1699: If l_debug_on then
1700: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1701: wsh_debug_sv.pop(l_module_name);
1702: End If;
1703: x_return_status := wsh_util_core.g_ret_sts_error;
1704:
1705: End update_parameter;
1706:
1707:

Line 1732: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;

1728: handle_exception exception;
1729: others exception;
1730:
1731: Begin
1732: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;
1733: l_debug_on := wsh_debug_interface.g_debug;
1734: If l_debug_on is null then
1735: l_debug_on := wsh_debug_sv.is_debug_enabled;
1736: End If;

Line 1758: x_return_status := wsh_util_core.G_RET_STS_ERROR;

1754: Fetch l_lock_csr into l_id ;
1755: Close l_lock_csr;
1756:
1757: If l_id is null then
1758: x_return_status := wsh_util_core.G_RET_STS_ERROR;
1759: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1760: If l_debug_on then
1761: wsh_debug_sv.log(l_module_name,'Value of L_ID = ',l_id);
1762: wsh_debug_sv.log(l_module_name,'Record dosent exists for the ORG ID ',p_organization_id);

Line 1775: x_return_status := wsh_util_core.g_ret_sts_error;

1771: End If;
1772:
1773: Exception
1774: When handle_exception then
1775: x_return_status := wsh_util_core.g_ret_sts_error;
1776: If l_debug_on then
1777: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1778: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
1779: wsh_debug_sv.pop(l_module_name);

Line 1783: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

1779: wsh_debug_sv.pop(l_module_name);
1780: End If;
1781: When Others then
1782: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1783: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1784: If l_debug_on then
1785: wsh_debug_sv.log(l_module_name,'Unexpected Error Occured During Locking for Org Id ',p_organization_id);
1786: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );
1787: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);

Line 1810: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;

1806: l_debug_on boolean;
1807: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_LAYOUT_TEMPLATE';
1808:
1809: Begin
1810: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;
1811: l_debug_on := wsh_debug_interface.g_debug;
1812: If l_debug_on is null then
1813: l_debug_on := wsh_debug_sv.is_debug_enabled;
1814: End If;

Line 1833: x_return_status := wsh_util_core.G_RET_STS_ERROR;

1829: End If;
1830:
1831: Exception
1832: When Others then
1833: x_return_status := wsh_util_core.G_RET_STS_ERROR;
1834: If l_debug_on then
1835: wsh_debug_sv.log(l_module_name,'Unexpected Error Occured while getting tamplate name ',p_concprg_name||' '||p_code_field);
1836: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );
1837: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);

Line 1999: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);

1995:
1996: type l_parameter_value_type is table of wsh_shipping_parameter_values.PARAM_VALUE%TYPE index by binary_integer;
1997:
1998: l_freight_terms_value l_parameter_value_type;
1999: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);
2000: l_user_id number:= fnd_global.user_id;
2001: l_login_id number:= fnd_global.login_id;
2002: l_debug_on boolean;
2003: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_FREIGHT_TERMS';

Line 2132: x_return_status := wsh_util_core.g_ret_sts_error;

2128: End If;
2129:
2130: Exception
2131: When handle_exception then
2132: x_return_status := wsh_util_core.g_ret_sts_error;
2133: If l_debug_on then
2134: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2135: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2136: wsh_debug_sv.pop(l_module_name);

Line 2139: x_return_status := wsh_util_core.g_ret_sts_error;

2135: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2136: wsh_debug_sv.pop(l_module_name);
2137: End If;
2138: When others then
2139: x_return_status := wsh_util_core.g_ret_sts_error;
2140: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2141: fnd_message.set_token('PACKAGE',l_module_name);
2142: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2143: fnd_message.set_token('ORA_TEXT',SQLERRM);

Line 2177: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);

2173: l_login_id number:= fnd_global.login_id;
2174: l_debug_on boolean;
2175: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_FREIGHT_TERMS';
2176: l_return_status varchar2(10);
2177: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);
2178: l_freight_terms varchar2(240);
2179: handle_exception exception;
2180:
2181: Begin

Line 2265: x_return_status := wsh_util_core.g_ret_sts_error;

2261: End If;
2262:
2263: Exception
2264: When handle_exception then
2265: x_return_status := wsh_util_core.g_ret_sts_error;
2266: If l_debug_on then
2267: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2268: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2269: wsh_debug_sv.pop(l_module_name);

Line 2272: x_return_status := wsh_util_core.g_ret_sts_error;

2268: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2269: wsh_debug_sv.pop(l_module_name);
2270: End If;
2271: When others then
2272: x_return_status := wsh_util_core.g_ret_sts_error;
2273: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2274: fnd_message.set_token('PACKAGE',l_module_name);
2275: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2276: fnd_message.set_token('ORA_TEXT',SQLERRM);

Line 2327: x_return_status := wsh_util_core.g_ret_sts_error;

2323: End If;
2324:
2325: Exception
2326: When others then
2327: x_return_status := wsh_util_core.g_ret_sts_error;
2328: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2329: fnd_message.set_token('PACKAGE',l_module_name);
2330: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2331: fnd_message.set_token('ORA_TEXT',SQLERRM);