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_FILE

Line 165: -- fnd_file.put_line(fnd_file.Log, 'inserting into fte regions interface, interface and tl only flag both = Y');

161: IF (p_interface_flag = 'Y') THEN
162:
163: IF (p_tl_only_flag <> 'Y') THEN
164:
165: -- fnd_file.put_line(fnd_file.Log, 'inserting into fte regions interface, interface and tl only flag both = Y');
166:
167: INSERT INTO WSH_REGIONS_INTERFACE (
168: REGION_ID,
169: REGION_TYPE,

Line 427: -- fnd_file.put_line(fnd_file.Log, 'in Get_Parent_Region_Id '||p_parent_region_type);

423: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_PARENT_REGION_INFO';
424: --
425: BEGIN
426:
427: -- fnd_file.put_line(fnd_file.Log, 'in Get_Parent_Region_Id '||p_parent_region_type);
428:
429: --
430: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
431: --

Line 483: fnd_file.put_line(fnd_file.log,'Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Info_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;
487: END IF;

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 531: fnd_file.put_line(fnd_file.log,'1. Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only');

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

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 557: fnd_file.put_line(fnd_file.log,'2. Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only');

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

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 593: -- fnd_file.put_line(fnd_file.log,'parent region exists in tl table. cannot insert new one '||l_parent_region_id_non_tl||' x '||l_check_tl_id);

589:
590: END IF;
591:
592: IF (l_parent_region_id_non_tl <> -1 AND l_check_tl_id <> -1) THEN
593: -- fnd_file.put_line(fnd_file.log,'parent region exists in tl table. cannot insert new one '||l_parent_region_id_non_tl||' x '||l_check_tl_id);
594: x_parent_region_info.region_id := -1;
595: --
596: -- Debug Statements
597: --

Line 1483: -- fnd_file.put_line(fnd_file.log,'after region id codes 1 '||l_region_id||' x '||l_check_tl_id);

1479: p_lang_code => p_lang_code,
1480: x_region_id_non_tl => l_region_id,
1481: x_region_id_with_tl => l_check_tl_id);
1482:
1483: -- fnd_file.put_line(fnd_file.log,'after region id codes 1 '||l_region_id||' x '||l_check_tl_id);
1484: IF (l_region_id <> -1 AND l_check_tl_id <> -1) THEN
1485: x_status := 2;
1486: x_error_msg := 'WSH_CAT_REGION_EXISTS';
1487: x_region_id := -1;

Line 1704: -- fnd_file.put_line(fnd_file.log,'after region id codes 2 '||l_region_id||' x '||l_check_tl_id);

1700: x_region_id_non_tl => l_region_id,
1701: x_region_id_with_tl => l_check_tl_id);
1702: END IF;
1703:
1704: -- fnd_file.put_line(fnd_file.log,'after region id codes 2 '||l_region_id||' x '||l_check_tl_id);
1705: IF (l_region_id <> -1 AND l_check_tl_id <> -1) THEN
1706: x_status := 2;
1707: x_error_msg := 'WSH_CAT_DUPLICATE_REGION';
1708: x_region_id := -1;

Line 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));

3980: IF (l_status = 2) THEN
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;

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 4025: fnd_file.put_line(fnd_file.log, 'TIME TAKEN FOR PROCESSING 1000 RECORDS : ' || ((dbms_utility.get_time - t1)/100));

4021: -- Deleting region ids from array
4022: l_del_region_id.DELETE;
4023: END IF;
4024:
4025: fnd_file.put_line(fnd_file.log, 'TIME TAKEN FOR PROCESSING 1000 RECORDS : ' || ((dbms_utility.get_time - t1)/100));
4026:
4027: COMMIT;
4028: EXIT WHEN get_all_regions%NOTFOUND;
4029: END LOOP;

Line 4121: fnd_file.put_line(fnd_file.log,'Started the region upload process...');

4117:
4118: OPEN total_regions;
4119: FETCH total_regions INTO l_total_regions;
4120: CLOSE total_regions;
4121: fnd_file.put_line(fnd_file.log,'Started the region upload process...');
4122:
4123: IF (l_total_regions > 0) THEN
4124: Default_Regions(l_dummy_country,
4125: l_country_code,

Line 4135: fnd_file.put_line(fnd_file.log,'Summary: Total regions to be processed before submit = '||l_total_regions);

4131:
4132: l_good_count := l_regions_processed;
4133: l_bad_count := l_total_regions - l_regions_processed;
4134:
4135: fnd_file.put_line(fnd_file.log,'Summary: Total regions to be processed before submit = '||l_total_regions);
4136: fnd_file.put_line(fnd_file.log,'Summary: Number of new regions = '||l_good_count);
4137: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with (not interfaced) = '||l_bad_count);
4138:
4139: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');

Line 4136: fnd_file.put_line(fnd_file.log,'Summary: Number of new regions = '||l_good_count);

4132: l_good_count := l_regions_processed;
4133: l_bad_count := l_total_regions - l_regions_processed;
4134:
4135: fnd_file.put_line(fnd_file.log,'Summary: Total regions to be processed before submit = '||l_total_regions);
4136: fnd_file.put_line(fnd_file.log,'Summary: Number of new regions = '||l_good_count);
4137: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with (not interfaced) = '||l_bad_count);
4138:
4139: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');
4140: errbuf := 'Submission is completed ';

Line 4137: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with (not interfaced) = '||l_bad_count);

4133: l_bad_count := l_total_regions - l_regions_processed;
4134:
4135: fnd_file.put_line(fnd_file.log,'Summary: Total regions to be processed before submit = '||l_total_regions);
4136: fnd_file.put_line(fnd_file.log,'Summary: Number of new regions = '||l_good_count);
4137: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with (not interfaced) = '||l_bad_count);
4138:
4139: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');
4140: errbuf := 'Submission is completed ';
4141: retcode := '0';

Line 4139: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');

4135: fnd_file.put_line(fnd_file.log,'Summary: Total regions to be processed before submit = '||l_total_regions);
4136: fnd_file.put_line(fnd_file.log,'Summary: Number of new regions = '||l_good_count);
4137: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with (not interfaced) = '||l_bad_count);
4138:
4139: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');
4140: errbuf := 'Submission is completed ';
4141: retcode := '0';
4142: ELSE
4143: fnd_file.put_line(fnd_file.log,'There are no valid regions in interface table. If any regions exist please correct them and resubmit the concurrent program.');

Line 4143: fnd_file.put_line(fnd_file.log,'There are no valid regions in interface table. If any regions exist please correct them and resubmit the concurrent program.');

4139: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');
4140: errbuf := 'Submission is completed ';
4141: retcode := '0';
4142: ELSE
4143: fnd_file.put_line(fnd_file.log,'There are no valid regions in interface table. If any regions exist please correct them and resubmit the concurrent program.');
4144: errbuf := 'Submission is completed ';
4145: retcode := '0';
4146:
4147: END IF;

Line 4643: fnd_file.put_line(fnd_file.log, 'INSIDE VALIDATE_REGION EXCEPTION : ' || sqlerrm);

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: --
4647: -- PROCEDURE : Init_Global_Table

Line 5096: fnd_file.put_line(fnd_file.log, 'Init_Global_Table EXCEPTION : ' || sqlerrm);

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: --
5100: -- PROCEDURE : Insert_Global_Table

Line 5254: fnd_file.put_line(fnd_file.log, 'INSERT_GLOBAL_TABLE EXCEPTION : ' || sqlerrm);

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: --
5258: -- PROCEDURE : Update_Global_Table

Line 5467: fnd_file.put_line(fnd_file.log, 'UPDATE_GLOBAL_TABLE EXCEPTION : ' || sqlerrm);

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