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

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

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

4012: -- Deleting region ids from array
4013: l_del_region_id.DELETE;
4014: END IF;
4015:
4016: fnd_file.put_line(fnd_file.log, 'TIME TAKEN FOR PROCESSING 1000 RECORDS : ' || ((dbms_utility.get_time - t1)/100));
4017:
4018: COMMIT;
4019: EXIT WHEN get_all_regions%NOTFOUND;
4020: END LOOP;

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

4100:
4101: OPEN total_regions;
4102: FETCH total_regions INTO l_total_regions;
4103: CLOSE total_regions;
4104: fnd_file.put_line(fnd_file.log,'Started the region upload process...');
4105:
4106: IF (l_total_regions > 0) THEN
4107: Default_Regions(l_status, l_regions_processed, l_error_msg_text);
4108:

Line 4112: fnd_file.put_line(fnd_file.log,'Summary: Total regions processed = '||l_total_regions);

4108:
4109: l_good_count := l_regions_processed;
4110: l_bad_count := l_total_regions - l_regions_processed;
4111:
4112: fnd_file.put_line(fnd_file.log,'Summary: Total regions processed = '||l_total_regions);
4113: fnd_file.put_line(fnd_file.log,'Summary: Number of new regions = '||l_good_count);
4114: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with errors (not interfaced) = '||l_bad_count);
4115:
4116: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');

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

4109: l_good_count := l_regions_processed;
4110: l_bad_count := l_total_regions - l_regions_processed;
4111:
4112: fnd_file.put_line(fnd_file.log,'Summary: Total regions processed = '||l_total_regions);
4113: fnd_file.put_line(fnd_file.log,'Summary: Number of new regions = '||l_good_count);
4114: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with errors (not interfaced) = '||l_bad_count);
4115:
4116: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');
4117: ELSE

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

4110: l_bad_count := l_total_regions - l_regions_processed;
4111:
4112: fnd_file.put_line(fnd_file.log,'Summary: Total regions processed = '||l_total_regions);
4113: fnd_file.put_line(fnd_file.log,'Summary: Number of new regions = '||l_good_count);
4114: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with errors (not interfaced) = '||l_bad_count);
4115:
4116: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');
4117: ELSE
4118: 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 4116: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');

4112: fnd_file.put_line(fnd_file.log,'Summary: Total regions processed = '||l_total_regions);
4113: fnd_file.put_line(fnd_file.log,'Summary: Number of new regions = '||l_good_count);
4114: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with errors (not interfaced) = '||l_bad_count);
4115:
4116: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');
4117: ELSE
4118: 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.');
4119:
4120: END IF;

Line 4118: 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.');

4114: fnd_file.put_line(fnd_file.log,'Summary: Number of regions with errors (not interfaced) = '||l_bad_count);
4115:
4116: fnd_file.put_line(fnd_file.log,'Ended the region upload process.');
4117: ELSE
4118: 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.');
4119:
4120: END IF;
4121:
4122: --

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

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

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

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

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

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

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

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