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 2911: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

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

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

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

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

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

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

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

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

3981: x_status := 2;
3982: x_error_msg_text := l_error_msg;
3983:
3984: 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));
3985: fnd_file.put_line(fnd_file.log,' error message: '||fnd_message.get_string('WSH',l_error_msg));
3986:
3987: -- Bulk Update has to be done after processing 1000 records
3988: l_upd_count := l_upd_count + 1;
3989: l_upd_region_id(l_upd_count) := l_region_id_rec(i);

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

4637: EXCEPTION
4638: WHEN OTHERS THEN
4639: x_status := 2;
4640: x_error_msg := 'WSH_UTIL_MESSAGE_U';
4641: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
4642: fnd_message.set_token('MSG_TEXT', SQLERRM);
4643: fnd_file.put_line(fnd_file.log, 'INSIDE VALIDATE_REGION EXCEPTION : ' || sqlerrm);
4644: END Validate_Region;
4645:

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

4638: WHEN OTHERS THEN
4639: x_status := 2;
4640: x_error_msg := 'WSH_UTIL_MESSAGE_U';
4641: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
4642: fnd_message.set_token('MSG_TEXT', SQLERRM);
4643: fnd_file.put_line(fnd_file.log, 'INSIDE VALIDATE_REGION EXCEPTION : ' || sqlerrm);
4644: END Validate_Region;
4645:
4646: --

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

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;
5098:

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

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;
5098:
5099: --

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

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;
5256:

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

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;
5256:
5257: --

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

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;
5469:

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

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;
5469:
5470: END WSH_REGIONS_PKG;