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 303: FND_MESSAGE.Set_Token('ORG_NAME', wsh_util_core.get_org_name(p_organization_id));

299: IF c_get_param%NOTFOUND THEN
300: --Bug 3539616 : Error message shown when Shipping Parameters are not defined
301:
302: FND_MESSAGE.Set_Name('WSH', 'WSH_SHP_NOT_FOUND');
303: FND_MESSAGE.Set_Token('ORG_NAME', wsh_util_core.get_org_name(p_organization_id));
304:
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.log(l_module_name,'ERROR: ','Shipping Parameters not defined for Organization '||p_organization_id);
307: END IF;

Line 794: l_parameter_name wsh_util_core.column_tab_type;

790: where organization_id = p_organization_id ;
791:
792: type l_varchar2_tbl is table of wsh_shipping_parameter_values.param_value%TYPE index by binary_integer;
793: l_param_value l_varchar2_tbl;
794: l_parameter_name wsh_util_core.column_tab_type;
795: l_param_value_info parameter_value_rec_typ;
796: temp_param_value_info parameter_value_rec_typ;
797: l_selective boolean;
798: l_row_count number;

Line 807: x_return_status := wsh_util_core.g_ret_sts_success;

803: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET ';
804:
805:
806: Begin
807: x_return_status := wsh_util_core.g_ret_sts_success;
808:
809: If x_param_value_info.param_name.count > 0 then
810: l_selective := TRUE;
811: l_parameter_name := x_param_value_info.param_name;

Line 931: x_return_status := wsh_util_core.g_ret_sts_error;

927: End If;
928:
929: Exception
930: When others then
931: x_return_status := wsh_util_core.g_ret_sts_error;
932: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
933: fnd_message.set_token('PACKAGE',l_module_name);
934: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
935: fnd_message.set_token('ORA_TEXT',SQLERRM);

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

990: l_login_id number:= fnd_global.login_id;
991: l_debug_on boolean;
992: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_PARAMETER';
993: l_return_status varchar2(1);
994: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_ship_par_rec.organization_id);
995: handle_exception exception;
996: l_freight_count number;
997: l_param_count number ;
998: l_sqlerrm varchar2(2000);

Line 1001: x_return_status := wsh_util_core.g_ret_sts_success;

997: l_param_count number ;
998: l_sqlerrm varchar2(2000);
999:
1000: Begin
1001: x_return_status := wsh_util_core.g_ret_sts_success;
1002: l_debug_on := wsh_debug_interface.g_debug;
1003: If l_debug_on is null then
1004: l_debug_on := wsh_debug_sv.is_debug_enabled;
1005: End If;

Line 1259: If l_return_status <> wsh_util_core.g_ret_sts_success then

1255:
1256: l_freight_terms_rec.organization_id := p_ship_par_val_rec.organization_id;
1257: create_freight_terms(l_freight_terms_rec
1258: ,l_return_status);
1259: If l_return_status <> wsh_util_core.g_ret_sts_success then
1260: If l_debug_on then
1261: wsh_debug_sv.log(l_module_name,'After call to create_freight_terms procedure l_return_status = ',l_return_status);
1262: End If;
1263: raise handle_exception;

Line 1334: x_return_status := wsh_util_core.g_ret_sts_error;

1330: End If;
1331:
1332: Exception
1333: When handle_exception then
1334: x_return_status := wsh_util_core.g_ret_sts_error;
1335: If l_debug_on then
1336: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1337: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);
1338: wsh_debug_sv.pop(l_module_name);

Line 1342: x_return_status := wsh_util_core.g_ret_sts_error;

1338: wsh_debug_sv.pop(l_module_name);
1339: End If;
1340:
1341: When others then
1342: x_return_status := wsh_util_core.g_ret_sts_error;
1343: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1344: fnd_message.set_token('PACKAGE',l_module_name);
1345: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1346: fnd_message.set_token('ORA_TEXT',SQLERRM);

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

1387: l_record_exists boolean := FALSE;
1388: ins_count number;
1389: upd_count number;
1390: l_debug_on boolean;
1391: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_ship_par_rec.organization_id);
1392: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_PARAMETER';
1393: l_freight_count number ;
1394: l_return_status varchar2(10);
1395: l_freight_terms varchar2(240);

Line 1417: x_return_status := wsh_util_core.g_ret_sts_success;

1413: handle_exception exception;
1414:
1415:
1416: Begin
1417: x_return_status := wsh_util_core.g_ret_sts_success;
1418: l_debug_on := wsh_debug_interface.g_debug;
1419: If l_debug_on is null then
1420: l_debug_on := wsh_debug_sv.is_debug_enabled;
1421: End If;

Line 1630: If l_return_status <> wsh_util_core.g_ret_sts_success then

1626: raise handle_exception;
1627: End;
1628: create_freight_terms(l_freight_terms_rec
1629: ,l_return_status);
1630: If l_return_status <> wsh_util_core.g_ret_sts_success then
1631: If l_debug_on then
1632: wsh_debug_sv.log(l_module_name,'After call to create_freight_terms procedure l_return_status = ',l_return_status);
1633: End If;
1634: raise handle_exception;

Line 1734: x_return_status := wsh_util_core.g_ret_sts_error;

1730: If l_debug_on then
1731: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1732: wsh_debug_sv.pop(l_module_name);
1733: End If;
1734: x_return_status := wsh_util_core.g_ret_sts_error;
1735:
1736: When others then
1737: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1738: fnd_message.set_token('PACKAGE',l_module_name);

Line 1745: x_return_status := wsh_util_core.g_ret_sts_error;

1741: If l_debug_on then
1742: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1743: wsh_debug_sv.pop(l_module_name);
1744: End If;
1745: x_return_status := wsh_util_core.g_ret_sts_error;
1746:
1747: End update_parameter;
1748:
1749:

Line 1774: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;

1770: handle_exception exception;
1771: others exception;
1772:
1773: Begin
1774: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;
1775: l_debug_on := wsh_debug_interface.g_debug;
1776: If l_debug_on is null then
1777: l_debug_on := wsh_debug_sv.is_debug_enabled;
1778: End If;

Line 1800: x_return_status := wsh_util_core.G_RET_STS_ERROR;

1796: Fetch l_lock_csr into l_id ;
1797: Close l_lock_csr;
1798:
1799: If l_id is null then
1800: x_return_status := wsh_util_core.G_RET_STS_ERROR;
1801: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1802: If l_debug_on then
1803: wsh_debug_sv.log(l_module_name,'Value of L_ID = ',l_id);
1804: wsh_debug_sv.log(l_module_name,'Record dosent exists for the ORG ID ',p_organization_id);

Line 1817: x_return_status := wsh_util_core.g_ret_sts_error;

1813: End If;
1814:
1815: Exception
1816: When handle_exception then
1817: x_return_status := wsh_util_core.g_ret_sts_error;
1818: If l_debug_on then
1819: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1820: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
1821: wsh_debug_sv.pop(l_module_name);

Line 1825: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

1821: wsh_debug_sv.pop(l_module_name);
1822: End If;
1823: When Others then
1824: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1825: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1826: If l_debug_on then
1827: wsh_debug_sv.log(l_module_name,'Unexpected Error Occured During Locking for Org Id ',p_organization_id);
1828: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );
1829: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);

Line 1852: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;

1848: l_debug_on boolean;
1849: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_LAYOUT_TEMPLATE';
1850:
1851: Begin
1852: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;
1853: l_debug_on := wsh_debug_interface.g_debug;
1854: If l_debug_on is null then
1855: l_debug_on := wsh_debug_sv.is_debug_enabled;
1856: End If;

Line 1875: x_return_status := wsh_util_core.G_RET_STS_ERROR;

1871: End If;
1872:
1873: Exception
1874: When Others then
1875: x_return_status := wsh_util_core.G_RET_STS_ERROR;
1876: If l_debug_on then
1877: wsh_debug_sv.log(l_module_name,'Unexpected Error Occured while getting tamplate name ',p_concprg_name||' '||p_code_field);
1878: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );
1879: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);

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

2037:
2038: type l_parameter_value_type is table of wsh_shipping_parameter_values.PARAM_VALUE%TYPE index by binary_integer;
2039:
2040: l_freight_terms_value l_parameter_value_type;
2041: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);
2042: l_user_id number:= fnd_global.user_id;
2043: l_login_id number:= fnd_global.login_id;
2044: l_debug_on boolean;
2045: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_FREIGHT_TERMS';

Line 2174: x_return_status := wsh_util_core.g_ret_sts_error;

2170: End If;
2171:
2172: Exception
2173: When handle_exception then
2174: x_return_status := wsh_util_core.g_ret_sts_error;
2175: If l_debug_on then
2176: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2177: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2178: wsh_debug_sv.pop(l_module_name);

Line 2181: x_return_status := wsh_util_core.g_ret_sts_error;

2177: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2178: wsh_debug_sv.pop(l_module_name);
2179: End If;
2180: When others then
2181: x_return_status := wsh_util_core.g_ret_sts_error;
2182: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2183: fnd_message.set_token('PACKAGE',l_module_name);
2184: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2185: fnd_message.set_token('ORA_TEXT',SQLERRM);

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

2215: l_login_id number:= fnd_global.login_id;
2216: l_debug_on boolean;
2217: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_FREIGHT_TERMS';
2218: l_return_status varchar2(10);
2219: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);
2220: l_freight_terms varchar2(240);
2221: handle_exception exception;
2222:
2223: Begin

Line 2307: x_return_status := wsh_util_core.g_ret_sts_error;

2303: End If;
2304:
2305: Exception
2306: When handle_exception then
2307: x_return_status := wsh_util_core.g_ret_sts_error;
2308: If l_debug_on then
2309: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2310: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2311: wsh_debug_sv.pop(l_module_name);

Line 2314: x_return_status := wsh_util_core.g_ret_sts_error;

2310: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2311: wsh_debug_sv.pop(l_module_name);
2312: End If;
2313: When others then
2314: x_return_status := wsh_util_core.g_ret_sts_error;
2315: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2316: fnd_message.set_token('PACKAGE',l_module_name);
2317: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2318: fnd_message.set_token('ORA_TEXT',SQLERRM);

Line 2369: x_return_status := wsh_util_core.g_ret_sts_error;

2365: End If;
2366:
2367: Exception
2368: When others then
2369: x_return_status := wsh_util_core.g_ret_sts_error;
2370: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2371: fnd_message.set_token('PACKAGE',l_module_name);
2372: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2373: fnd_message.set_token('ORA_TEXT',SQLERRM);