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 FND_MESSAGE

Line 484: fnd_file.put_line(fnd_file.log,'Error Message : '|| fnd_message.get_string('WSH', 'WSH_UTIL_MESSAGE_U') );

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;
487: END IF;
488: ELSE

Line 532: fnd_file.put_line(fnd_file.log,'1. Error Message : '|| fnd_message.get_string('WSH', 'WSH_UTIL_MESSAGE_U') );

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;
535: END IF;
536:

Line 558: fnd_file.put_line(fnd_file.log,'2. Error Message : '|| fnd_message.get_string('WSH', 'WSH_UTIL_MESSAGE_U') );

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;
561: END IF;
562: END IF;

Line 2210: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

2206: FETCH lock_row INTO Recinfo;
2207:
2208: IF (lock_row%NOTFOUND) THEN
2209: CLOSE lock_row;
2210: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
2211: app_exception.raise_exception;
2212: END IF;
2213:
2214: CLOSE lock_row;

Line 2269: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

2265: END IF;
2266: --
2267: RETURN;
2268: ELSE
2269: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2270: app_exception.raise_exception;
2271: END IF;
2272:
2273: OPEN lock_row_tl;

Line 2278: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

2274: FETCH lock_row_tl INTO Recinfo_tl;
2275:
2276: IF (lock_row_tl%NOTFOUND) THEN
2277: CLOSE lock_row_tl;
2278: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
2279: app_exception.raise_exception;
2280: END IF;
2281:
2282: CLOSE lock_row_tl;

Line 2306: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

2302: END IF;
2303: --
2304: RETURN;
2305: ELSE
2306: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2307: app_exception.raise_exception;
2308: END IF;
2309:
2310: --

Line 2327: fnd_message.set_name('WSH', 'WSH_FORM_RECORD_IS_CHANGED');

2323: if (lock_row_tl%ISOPEN) then
2324: close lock_row_tl;
2325: end if;
2326: -- Fixing Lock message bug
2327: fnd_message.set_name('WSH', 'WSH_FORM_RECORD_IS_CHANGED');
2328: app_exception.raise_exception;
2329: --
2330: -- Debug Statements
2331: --

Line 2435: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

2431: FETCH lock_row INTO Recinfo;
2432:
2433: IF (lock_row%NOTFOUND) THEN
2434: CLOSE lock_row;
2435: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
2436: app_exception.raise_exception;
2437: END IF;
2438:
2439: CLOSE lock_row;

Line 2459: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

2455: END IF;
2456: --
2457: RETURN;
2458: ELSE
2459: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2460: app_exception.raise_exception;
2461: END IF;
2462:
2463: OPEN lock_row_tl;

Line 2468: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

2464: FETCH lock_row_tl INTO Recinfo_tl;
2465:
2466: IF (lock_row_tl%NOTFOUND) THEN
2467: CLOSE lock_row_tl;
2468: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
2469: app_exception.raise_exception;
2470: END IF;
2471:
2472: CLOSE lock_row_tl;

Line 2496: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

2492: END IF;
2493: --
2494: RETURN;
2495: ELSE
2496: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2497: app_exception.raise_exception;
2498: END IF;
2499:
2500: --

Line 2910: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

2906: FETCH lock_row INTO Recinfo;
2907:
2908: IF (lock_row%NOTFOUND) THEN
2909: CLOSE lock_row;
2910: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
2911: app_exception.raise_exception;
2912: END IF;
2913:
2914: CLOSE lock_row;

Line 2931: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

2927: END IF;
2928: --
2929: RETURN;
2930: ELSE
2931: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2932: app_exception.raise_exception;
2933: END IF;
2934:
2935: --

Line 3484: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

3480: FETCH lock_row INTO Recinfo;
3481:
3482: IF (lock_row%NOTFOUND) THEN
3483: CLOSE lock_row;
3484: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
3485: app_exception.raise_exception;
3486: END IF;
3487:
3488: CLOSE lock_row;

Line 3504: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

3500: END IF;
3501: --
3502: RETURN;
3503: ELSE
3504: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3505: app_exception.raise_exception;
3506: END IF;
3507:
3508: --

Line 3976: fnd_file.put_line(fnd_file.log,' error message: '||fnd_message.get_string('WSH',l_error_msg));

3972: x_status := 2;
3973: x_error_msg_text := l_error_msg;
3974:
3975: fnd_file.put_line(fnd_file.log,'ERROR processing region: ' || l_country_rec(i) ||', '|| l_state_rec(i) || ', ' || l_city_rec(i) || ', ' || l_postal_code_from_rec(i));
3976: fnd_file.put_line(fnd_file.log,' error message: '||fnd_message.get_string('WSH',l_error_msg));
3977:
3978: -- Bulk Update has to be done after processing 1000 records
3979: l_upd_count := l_upd_count + 1;
3980: l_upd_region_id(l_upd_count) := l_region_id_rec(i);

Line 4614: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');

4610: EXCEPTION
4611: WHEN OTHERS THEN
4612: x_status := 2;
4613: x_error_msg := 'WSH_UTIL_MESSAGE_U';
4614: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
4615: fnd_message.set_token('MSG_TEXT', SQLERRM);
4616: fnd_file.put_line(fnd_file.log, 'INSIDE VALIDATE_REGION EXCEPTION : ' || sqlerrm);
4617: END Validate_Region;
4618:

Line 4615: fnd_message.set_token('MSG_TEXT', SQLERRM);

4611: WHEN OTHERS THEN
4612: x_status := 2;
4613: x_error_msg := 'WSH_UTIL_MESSAGE_U';
4614: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
4615: fnd_message.set_token('MSG_TEXT', SQLERRM);
4616: fnd_file.put_line(fnd_file.log, 'INSIDE VALIDATE_REGION EXCEPTION : ' || sqlerrm);
4617: END Validate_Region;
4618:
4619: --

Line 5031: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');

5027: -- Exception Handling part
5028: EXCEPTION
5029: WHEN OTHERS THEN
5030: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5031: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
5032: fnd_message.set_token('MSG_TEXT', SQLERRM);
5033: fnd_file.put_line(fnd_file.log, 'Init_Global_Table EXCEPTION : ' || sqlerrm);
5034: END Init_Global_Table;
5035:

Line 5032: fnd_message.set_token('MSG_TEXT', SQLERRM);

5028: EXCEPTION
5029: WHEN OTHERS THEN
5030: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5031: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
5032: fnd_message.set_token('MSG_TEXT', SQLERRM);
5033: fnd_file.put_line(fnd_file.log, 'Init_Global_Table EXCEPTION : ' || sqlerrm);
5034: END Init_Global_Table;
5035:
5036: --

Line 5189: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');

5185: -- Exception Handling part
5186: EXCEPTION
5187: WHEN OTHERS THEN
5188: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5189: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
5190: fnd_message.set_token('MSG_TEXT', SQLERRM);
5191: fnd_file.put_line(fnd_file.log, 'INSERT_GLOBAL_TABLE EXCEPTION : ' || sqlerrm);
5192: END Insert_Global_Table;
5193:

Line 5190: fnd_message.set_token('MSG_TEXT', SQLERRM);

5186: EXCEPTION
5187: WHEN OTHERS THEN
5188: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5189: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
5190: fnd_message.set_token('MSG_TEXT', SQLERRM);
5191: fnd_file.put_line(fnd_file.log, 'INSERT_GLOBAL_TABLE EXCEPTION : ' || sqlerrm);
5192: END Insert_Global_Table;
5193:
5194: --

Line 5402: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');

5398: -- Exception Handling part
5399: EXCEPTION
5400: WHEN OTHERS THEN
5401: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5402: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
5403: fnd_message.set_token('MSG_TEXT', SQLERRM);
5404: fnd_file.put_line(fnd_file.log, 'UPDATE_GLOBAL_TABLE EXCEPTION : ' || sqlerrm);
5405: END Update_Global_Table;
5406:

Line 5403: fnd_message.set_token('MSG_TEXT', SQLERRM);

5399: EXCEPTION
5400: WHEN OTHERS THEN
5401: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5402: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
5403: fnd_message.set_token('MSG_TEXT', SQLERRM);
5404: fnd_file.put_line(fnd_file.log, 'UPDATE_GLOBAL_TABLE EXCEPTION : ' || sqlerrm);
5405: END Update_Global_Table;
5406:
5407: END WSH_REGIONS_PKG;