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

Line 482: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

478: p_lang_code => p_lang_code,
479: x_return_status => l_return_status,
480: x_region_info => l_region_info);
481:
482: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
483: fnd_file.put_line(fnd_file.log,'Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Info_Code');
484: fnd_file.put_line(fnd_file.log,'Error Message : '|| fnd_message.get_string('WSH', 'WSH_UTIL_MESSAGE_U') );
485: l_region_info.region_id := -1;
486: return;

Line 530: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

526: IF ((p_city_code IS NULL OR p_city IS NOT NULL) AND
527: (p_state_code IS NULL OR p_state IS NOT NULL) AND
528: (p_country_code IS NULL OR p_country IS NOT NULL)) THEN
529:
530: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
531: fnd_file.put_line(fnd_file.log,'1. Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only');
532: fnd_file.put_line(fnd_file.log,'1. Error Message : '|| fnd_message.get_string('WSH', 'WSH_UTIL_MESSAGE_U') );
533: l_region_info.region_id := -1;
534: return;

Line 556: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

552: p_language_code => p_lang_code,
553: x_return_status => l_return_status,
554: x_region_id => l_check_tl_id);
555:
556: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
557: fnd_file.put_line(fnd_file.log,'2. Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only');
558: fnd_file.put_line(fnd_file.log,'2. Error Message : '|| fnd_message.get_string('WSH', 'WSH_UTIL_MESSAGE_U') );
559: l_region_info.region_id := -1;
560: return;

Line 1053: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1049: p_lang_code => p_lang_code,
1050: x_return_status => l_return_status );
1051:
1052: -- Error Handling Part
1053: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1054: THEN
1055: x_status := 2;
1056: x_error_msg := 'WSH_UTIL_MESSAGE_U';
1057: END IF;

Line 1293: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1289: p_lang_code => p_lang_code,
1290: x_return_status => l_return_status,
1291: x_region_info => l_region_info);
1292:
1293: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1294: THEN
1295: x_status := 2;
1296: x_error_msg := 'WSH_UTIL_MESSAGE_U';
1297: x_region_id := -1;

Line 1318: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1314: p_language_code => null,
1315: x_return_status => l_return_status,
1316: x_region_id => l_region_id);
1317:
1318: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1319: THEN
1320: x_status := 2;
1321: x_error_msg := 'WSH_UTIL_MESSAGE_U';
1322: x_region_id := -1;

Line 1344: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1340: p_language_code => p_lang_code,
1341: x_return_status => l_return_status,
1342: x_region_id => l_check_tl_id);
1343:
1344: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1345: THEN
1346: x_status := 2;
1347: x_error_msg := 'WSH_UTIL_MESSAGE_U';
1348: x_region_id := -1;

Line 1590: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1586: p_lang_code => p_lang_code,
1587: x_return_status => l_return_status,
1588: x_region_info => l_region_info);
1589:
1590: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1591: THEN
1592: x_status := 2;
1593: x_error_msg := 'WSH_UTIL_MESSAGE_U';
1594: x_region_id := -1;

Line 1649: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1645: p_language_code => null,
1646: x_return_status => l_return_status,
1647: x_region_id => l_region_id);
1648:
1649: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1650: THEN
1651: x_status := 2;
1652: x_error_msg := 'WSH_UTIL_MESSAGE_U';
1653: x_region_id := -1;

Line 1675: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1671: p_language_code => p_lang_code,
1672: x_return_status => l_return_status,
1673: x_region_id => l_check_tl_id);
1674:
1675: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1676: THEN
1677: x_status := 2;
1678: x_error_msg := 'WSH_UTIL_MESSAGE_U';
1679: x_region_id := -1;

Line 1962: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1958: p_lang_code => p_lang_code,
1959: x_return_status => l_return_status );
1960:
1961: -- Error Handling Part
1962: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1963: THEN
1964: x_status := 2;
1965: x_error_msg := 'WSH_UTIL_MESSAGE_U';
1966: x_region_id := -1;

Line 3752: l_upd_region_id WSH_UTIL_CORE.Id_Tab_Type;

3748: l_prev_state_code WSH_REGIONS.State_Code%Type;
3749: l_prev_city_code WSH_REGIONS.City_Code%Type;
3750:
3751: -- Variables for Updating and Deleting regions from Interface table in Bulk
3752: l_upd_region_id WSH_UTIL_CORE.Id_Tab_Type;
3753: l_del_region_id WSH_UTIL_CORE.Id_Tab_Type;
3754: l_upd_count NUMBER DEFAULT 0;
3755: l_del_count NUMBER DEFAULT 0;
3756:

Line 3753: l_del_region_id WSH_UTIL_CORE.Id_Tab_Type;

3749: l_prev_city_code WSH_REGIONS.City_Code%Type;
3750:
3751: -- Variables for Updating and Deleting regions from Interface table in Bulk
3752: l_upd_region_id WSH_UTIL_CORE.Id_Tab_Type;
3753: l_del_region_id WSH_UTIL_CORE.Id_Tab_Type;
3754: l_upd_count NUMBER DEFAULT 0;
3755: l_del_count NUMBER DEFAULT 0;
3756:
3757: l_return_status VARCHAR2(1);

Line 3920: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

3916: p_city_flag => l_city_flag,
3917: x_return_status => l_return_status );
3918:
3919: -- Error Handling Part
3920: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
3921: THEN
3922: l_status := 2;
3923: l_error_msg := 'WSH_UTIL_MESSAGE_U';
3924: END IF;

Line 4722: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4718: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_FLAG', P_CITY_FLAG);
4719: END IF;
4720: --
4721:
4722: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4723: t1 := dbms_utility.get_time;
4724:
4725: IF ( p_country_flag = 'Y' ) THEN -- { Region type 0 i.e., Country
4726: DELETE FROM WSH_REGIONS_GLOBAL_DATA;

Line 5093: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5089:
5090: -- Exception Handling part
5091: EXCEPTION
5092: WHEN OTHERS THEN
5093: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5094: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
5095: fnd_message.set_token('MSG_TEXT', SQLERRM);
5096: fnd_file.put_line(fnd_file.log, 'Init_Global_Table EXCEPTION : ' || sqlerrm);
5097: END Init_Global_Table;

Line 5166: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5162: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
5163: END IF;
5164: --
5165:
5166: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5167: t1 := dbms_utility.get_time;
5168: IF ( p_parent_region_id is null AND
5169: p_region_type = 0 )
5170: THEN

Line 5251: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5247:
5248: -- Exception Handling part
5249: EXCEPTION
5250: WHEN OTHERS THEN
5251: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5252: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
5253: fnd_message.set_token('MSG_TEXT', SQLERRM);
5254: fnd_file.put_line(fnd_file.log, 'INSERT_GLOBAL_TABLE EXCEPTION : ' || sqlerrm);
5255: END Insert_Global_Table;

Line 5331: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5327: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
5328: END IF;
5329: --
5330:
5331: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5332: l_region_upd_cnt := 0;
5333: l_region_ins_cnt := 0;
5334: l_region_data_upd_cnt := 0;
5335: l_region_data_ins_cnt := 0;

Line 5464: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5460:
5461: -- Exception Handling part
5462: EXCEPTION
5463: WHEN OTHERS THEN
5464: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5465: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
5466: fnd_message.set_token('MSG_TEXT', SQLERRM);
5467: fnd_file.put_line(fnd_file.log, 'UPDATE_GLOBAL_TABLE EXCEPTION : ' || sqlerrm);
5468: END Update_Global_Table;