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.FTE_DIST_DWNLD_PKG dependencies on UTL_FILE

Line 422: -- should be readable by UTL_FILE --

418: -- the DTT data. --
419: -- 3. p_src_filedir: The directory containing the DTT --
420: -- data file. There should be no --
421: -- trailing '/', and this directory --
422: -- should be readable by UTL_FILE --
423: -- 4. p_user_debug: turns the debugger on --
424: -- --
425: -- PARAMETERS (OUT): p_errbuf: A buffer of error messages --
426: -- p_retcode: The return code. A return code of '2' --

Line 1931: l_target_file utl_file.file_type;

1927: l_code_idx PLS_INTEGER;
1928: l_str_length NUMBER;
1929: l_dest_attr_string VARCHAR2(2000);
1930: l_origin_attr_string VARCHAR2(2000);
1931: l_target_file utl_file.file_type;
1932: l_origin_reg_id NUMBER;
1933: l_dest_reg_id NUMBER;
1934: l_download_file_id NUMBER;
1935: l_line_ctr PLS_INTEGER;

Line 4796: WSH_DEBUG_SV.logmsg(l_module_name,'opening the target file with parameters l_target_file := utl_file.fopen(l_download_dir, p_file_name,W,8192');

4792:
4793:
4794:
4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.logmsg(l_module_name,'opening the target file with parameters l_target_file := utl_file.fopen(l_download_dir, p_file_name,W,8192');
4797: END IF;
4798:
4799: l_target_file := utl_file.fopen(l_download_dir, p_file_name, 'W',8192);
4800:

Line 4799: l_target_file := utl_file.fopen(l_download_dir, p_file_name, 'W',8192);

4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.logmsg(l_module_name,'opening the target file with parameters l_target_file := utl_file.fopen(l_download_dir, p_file_name,W,8192');
4797: END IF;
4798:
4799: l_target_file := utl_file.fopen(l_download_dir, p_file_name, 'W',8192);
4800:
4801:
4802: --
4803: -- Now we create the file data

Line 4809: utl_file.put_line(l_target_file,l_od_pair_tab(axe1).file_line);

4805: l_line_ctr := 0;
4806: FOR axe1 IN l_od_pair_tab.FIRST..l_od_pair_tab.LAST LOOP
4807: IF (l_od_pair_tab.EXISTS(axe1)) THEN
4808:
4809: utl_file.put_line(l_target_file,l_od_pair_tab(axe1).file_line);
4810: utl_file.fflush(l_target_file);
4811:
4812: l_line_ctr := l_line_ctr + 1;
4813: IF l_debug_on THEN

Line 4810: utl_file.fflush(l_target_file);

4806: FOR axe1 IN l_od_pair_tab.FIRST..l_od_pair_tab.LAST LOOP
4807: IF (l_od_pair_tab.EXISTS(axe1)) THEN
4808:
4809: utl_file.put_line(l_target_file,l_od_pair_tab(axe1).file_line);
4810: utl_file.fflush(l_target_file);
4811:
4812: l_line_ctr := l_line_ctr + 1;
4813: IF l_debug_on THEN
4814: WSH_DEBUG_SV.log(l_module_name,'insert into fte_mile_download_lines - line number = ',l_line_ctr);

Line 4852: utl_file.fclose(l_target_file);

4848: IF l_debug_on THEN
4849: WSH_DEBUG_SV.logmsg(l_module_name,' closing the file ');
4850: END IF;
4851:
4852: utl_file.fclose(l_target_file);
4853:
4854:
4855: --
4856: -- If we are here then all has gone well

Line 4894: IF (utl_file.is_open(l_target_file)) THEN

4890: WSH_UTIL_CORE.add_message(x_return_status);
4891: --
4892: -- Close the file
4893: --
4894: IF (utl_file.is_open(l_target_file)) THEN
4895: utl_file.fclose(l_target_file);
4896: END IF;
4897:
4898: --

Line 4895: utl_file.fclose(l_target_file);

4891: --
4892: -- Close the file
4893: --
4894: IF (utl_file.is_open(l_target_file)) THEN
4895: utl_file.fclose(l_target_file);
4896: END IF;
4897:
4898: --
4899: -- Close cursors

Line 4950: IF (utl_file.is_open(l_target_file)) THEN

4946: WSH_UTIL_CORE.add_message(x_return_status);
4947: --
4948: -- Close the file
4949: --
4950: IF (utl_file.is_open(l_target_file)) THEN
4951: utl_file.fclose(l_target_file);
4952: END IF;
4953:
4954: --

Line 4951: utl_file.fclose(l_target_file);

4947: --
4948: -- Close the file
4949: --
4950: IF (utl_file.is_open(l_target_file)) THEN
4951: utl_file.fclose(l_target_file);
4952: END IF;
4953:
4954: --
4955: -- Close cursors

Line 5007: IF (utl_file.is_open(l_target_file)) THEN

5003: WSH_UTIL_CORE.add_message(x_return_status);
5004: --
5005: -- Close the file
5006: --
5007: IF (utl_file.is_open(l_target_file)) THEN
5008: utl_file.fclose(l_target_file);
5009: END IF;
5010:
5011: --

Line 5008: utl_file.fclose(l_target_file);

5004: --
5005: -- Close the file
5006: --
5007: IF (utl_file.is_open(l_target_file)) THEN
5008: utl_file.fclose(l_target_file);
5009: END IF;
5010:
5011: --
5012: -- Close cursors

Line 5067: IF (utl_file.is_open(l_target_file)) THEN

5063:
5064: --
5065: -- close file
5066: --
5067: IF (utl_file.is_open(l_target_file)) THEN
5068: utl_file.fclose(l_target_file);
5069: END IF;
5070:
5071: --

Line 5068: utl_file.fclose(l_target_file);

5064: --
5065: -- close file
5066: --
5067: IF (utl_file.is_open(l_target_file)) THEN
5068: utl_file.fclose(l_target_file);
5069: END IF;
5070:
5071: --
5072: -- Close cursors

Line 5123: IF (utl_file.is_open(l_target_file)) THEN

5119: WSH_UTIL_CORE.add_message(x_return_status);
5120: --
5121: -- Close the file
5122: --
5123: IF (utl_file.is_open(l_target_file)) THEN
5124: utl_file.fclose(l_target_file);
5125: END IF;
5126:
5127: --

Line 5124: utl_file.fclose(l_target_file);

5120: --
5121: -- Close the file
5122: --
5123: IF (utl_file.is_open(l_target_file)) THEN
5124: utl_file.fclose(l_target_file);
5125: END IF;
5126:
5127: --
5128: -- Close cursors

Line 5179: IF (utl_file.is_open(l_target_file)) THEN

5175: WSH_UTIL_CORE.add_message(x_return_status);
5176: --
5177: -- Close the file
5178: --
5179: IF (utl_file.is_open(l_target_file)) THEN
5180: utl_file.fclose(l_target_file);
5181: END IF;
5182:
5183:

Line 5180: utl_file.fclose(l_target_file);

5176: --
5177: -- Close the file
5178: --
5179: IF (utl_file.is_open(l_target_file)) THEN
5180: utl_file.fclose(l_target_file);
5181: END IF;
5182:
5183:
5184: --

Line 5237: IF (utl_file.is_open(l_target_file)) THEN

5233: WSH_UTIL_CORE.add_message(x_return_status);
5234: --
5235: -- Close the file
5236: --
5237: IF (utl_file.is_open(l_target_file)) THEN
5238: utl_file.fclose(l_target_file);
5239: END IF;
5240:
5241: --

Line 5238: utl_file.fclose(l_target_file);

5234: --
5235: -- Close the file
5236: --
5237: IF (utl_file.is_open(l_target_file)) THEN
5238: utl_file.fclose(l_target_file);
5239: END IF;
5240:
5241: --
5242: -- Close cursors

Line 5293: IF (utl_file.is_open(l_target_file)) THEN

5289: WSH_UTIL_CORE.add_message(x_return_status);
5290: --
5291: -- Close the file
5292: --
5293: IF (utl_file.is_open(l_target_file)) THEN
5294: utl_file.fclose(l_target_file);
5295: END IF;
5296:
5297: --

Line 5294: utl_file.fclose(l_target_file);

5290: --
5291: -- Close the file
5292: --
5293: IF (utl_file.is_open(l_target_file)) THEN
5294: utl_file.fclose(l_target_file);
5295: END IF;
5296:
5297: --
5298: -- Close cursors

Line 5350: IF (utl_file.is_open(l_target_file)) THEN

5346: WSH_UTIL_CORE.add_message(x_return_status);
5347: --
5348: -- Close the file
5349: --
5350: IF (utl_file.is_open(l_target_file)) THEN
5351: utl_file.fclose(l_target_file);
5352: END IF;
5353:
5354:

Line 5351: utl_file.fclose(l_target_file);

5347: --
5348: -- Close the file
5349: --
5350: IF (utl_file.is_open(l_target_file)) THEN
5351: utl_file.fclose(l_target_file);
5352: END IF;
5353:
5354:
5355: --

Line 5404: IF (utl_file.is_open(l_target_file)) THEN

5400: WSH_UTIL_CORE.add_message(x_return_status);
5401: --
5402: -- Close the file
5403: --
5404: IF (utl_file.is_open(l_target_file)) THEN
5405: utl_file.fclose(l_target_file);
5406: END IF;
5407: --
5408: -- Close cursors

Line 5405: utl_file.fclose(l_target_file);

5401: --
5402: -- Close the file
5403: --
5404: IF (utl_file.is_open(l_target_file)) THEN
5405: utl_file.fclose(l_target_file);
5406: END IF;
5407: --
5408: -- Close cursors
5409: --

Line 5460: IF (utl_file.is_open(l_target_file)) THEN

5456: WSH_UTIL_CORE.add_message(x_return_status);
5457: --
5458: -- Close the file
5459: --
5460: IF (utl_file.is_open(l_target_file)) THEN
5461: utl_file.fclose(l_target_file);
5462: END IF;
5463:
5464: --

Line 5461: utl_file.fclose(l_target_file);

5457: --
5458: -- Close the file
5459: --
5460: IF (utl_file.is_open(l_target_file)) THEN
5461: utl_file.fclose(l_target_file);
5462: END IF;
5463:
5464: --
5465: -- Close cursors

Line 5515: IF (utl_file.is_open(l_target_file)) THEN

5511: WSH_UTIL_CORE.add_message(x_return_status);
5512: --
5513: -- Close the file
5514: --
5515: IF (utl_file.is_open(l_target_file)) THEN
5516: utl_file.fclose(l_target_file);
5517: END IF;
5518:
5519: --

Line 5516: utl_file.fclose(l_target_file);

5512: --
5513: -- Close the file
5514: --
5515: IF (utl_file.is_open(l_target_file)) THEN
5516: utl_file.fclose(l_target_file);
5517: END IF;
5518:
5519: --
5520: -- Close cursors

Line 5570: IF (utl_file.is_open(l_target_file)) THEN

5566: WSH_UTIL_CORE.add_message(x_return_status);
5567: --
5568: -- Close the file
5569: --
5570: IF (utl_file.is_open(l_target_file)) THEN
5571: utl_file.fclose(l_target_file);
5572: END IF;
5573:
5574:

Line 5571: utl_file.fclose(l_target_file);

5567: --
5568: -- Close the file
5569: --
5570: IF (utl_file.is_open(l_target_file)) THEN
5571: utl_file.fclose(l_target_file);
5572: END IF;
5573:
5574:
5575: --

Line 5626: IF (utl_file.is_open(l_target_file)) THEN

5622: WSH_UTIL_CORE.add_message(x_return_status);
5623: --
5624: -- Close the file
5625: --
5626: IF (utl_file.is_open(l_target_file)) THEN
5627: utl_file.fclose(l_target_file);
5628: END IF;
5629:
5630: --

Line 5627: utl_file.fclose(l_target_file);

5623: --
5624: -- Close the file
5625: --
5626: IF (utl_file.is_open(l_target_file)) THEN
5627: utl_file.fclose(l_target_file);
5628: END IF;
5629:
5630: --
5631: -- Close cursors

Line 5681: IF (utl_file.is_open(l_target_file)) THEN

5677: WSH_UTIL_CORE.add_message(x_return_status);
5678: --
5679: -- Close the file
5680: --
5681: IF (utl_file.is_open(l_target_file)) THEN
5682: utl_file.fclose(l_target_file);
5683: END IF;
5684:
5685: --

Line 5682: utl_file.fclose(l_target_file);

5678: --
5679: -- Close the file
5680: --
5681: IF (utl_file.is_open(l_target_file)) THEN
5682: utl_file.fclose(l_target_file);
5683: END IF;
5684:
5685: --
5686: -- Close cursors

Line 5729: WHEN utl_file.invalid_path THEN

5725: --
5726: RETURN;
5727:
5728:
5729: WHEN utl_file.invalid_path THEN
5730: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_FILE_PATH');
5731: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5732: x_return_message := FND_MESSAGE.GET;
5733: WSH_UTIL_CORE.add_message(x_return_status);

Line 5737: IF (utl_file.is_open(l_target_file)) THEN

5733: WSH_UTIL_CORE.add_message(x_return_status);
5734: --
5735: -- Close the file
5736: --
5737: IF (utl_file.is_open(l_target_file)) THEN
5738: utl_file.fclose(l_target_file);
5739: END IF;
5740:
5741: --

Line 5738: utl_file.fclose(l_target_file);

5734: --
5735: -- Close the file
5736: --
5737: IF (utl_file.is_open(l_target_file)) THEN
5738: utl_file.fclose(l_target_file);
5739: END IF;
5740:
5741: --
5742: -- Close cursors

Line 5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');

5772: --
5773: -- Debug Statements
5774: --
5775: IF l_debug_on THEN
5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');
5777: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_path exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_path');
5779: WSH_DEBUG_SV.pop(l_module_name);
5780: END IF;

Line 5777: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_path exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

5773: -- Debug Statements
5774: --
5775: IF l_debug_on THEN
5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');
5777: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_path exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_path');
5779: WSH_DEBUG_SV.pop(l_module_name);
5780: END IF;
5781: --

Line 5778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_path');

5774: --
5775: IF l_debug_on THEN
5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');
5777: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_path exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_path');
5779: WSH_DEBUG_SV.pop(l_module_name);
5780: END IF;
5781: --
5782: RETURN;

Line 5784: WHEN utl_file.invalid_mode THEN

5780: END IF;
5781: --
5782: RETURN;
5783:
5784: WHEN utl_file.invalid_mode THEN
5785: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_FILE_MODE');
5786: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5787: x_return_message := FND_MESSAGE.GET;
5788: WSH_UTIL_CORE.add_message(x_return_status);

Line 5792: IF (utl_file.is_open(l_target_file)) THEN

5788: WSH_UTIL_CORE.add_message(x_return_status);
5789: --
5790: -- Close the file
5791: --
5792: IF (utl_file.is_open(l_target_file)) THEN
5793: utl_file.fclose(l_target_file);
5794: END IF;
5795:
5796: --

Line 5793: utl_file.fclose(l_target_file);

5789: --
5790: -- Close the file
5791: --
5792: IF (utl_file.is_open(l_target_file)) THEN
5793: utl_file.fclose(l_target_file);
5794: END IF;
5795:
5796: --
5797: -- Close cursors

Line 5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');

5827: --
5828: -- Debug Statements
5829: --
5830: IF l_debug_on THEN
5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');
5832: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_mode exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_mode');
5834: WSH_DEBUG_SV.pop(l_module_name);
5835: END IF;

Line 5832: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_mode exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

5828: -- Debug Statements
5829: --
5830: IF l_debug_on THEN
5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');
5832: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_mode exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_mode');
5834: WSH_DEBUG_SV.pop(l_module_name);
5835: END IF;
5836: --

Line 5833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_mode');

5829: --
5830: IF l_debug_on THEN
5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');
5832: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_mode exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_mode');
5834: WSH_DEBUG_SV.pop(l_module_name);
5835: END IF;
5836: --
5837: RETURN;

Line 5839: WHEN utl_file.invalid_operation THEN

5835: END IF;
5836: --
5837: RETURN;
5838:
5839: WHEN utl_file.invalid_operation THEN
5840: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_FILE_OPERATION');
5841: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5842: x_return_message := FND_MESSAGE.GET;
5843: WSH_UTIL_CORE.add_message(x_return_status);

Line 5847: IF (utl_file.is_open(l_target_file)) THEN

5843: WSH_UTIL_CORE.add_message(x_return_status);
5844: --
5845: -- Close the file
5846: --
5847: IF (utl_file.is_open(l_target_file)) THEN
5848: utl_file.fclose(l_target_file);
5849: END IF;
5850:
5851:

Line 5848: utl_file.fclose(l_target_file);

5844: --
5845: -- Close the file
5846: --
5847: IF (utl_file.is_open(l_target_file)) THEN
5848: utl_file.fclose(l_target_file);
5849: END IF;
5850:
5851:
5852: --

Line 5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');

5883: --
5884: -- Debug Statements
5885: --
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');
5888: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_operation exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_operation');
5890: WSH_DEBUG_SV.pop(l_module_name);
5891: END IF;

Line 5888: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_operation exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

5884: -- Debug Statements
5885: --
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');
5888: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_operation exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_operation');
5890: WSH_DEBUG_SV.pop(l_module_name);
5891: END IF;
5892: --

Line 5889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_operation');

5885: --
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');
5888: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_operation exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_operation');
5890: WSH_DEBUG_SV.pop(l_module_name);
5891: END IF;
5892: --
5893: RETURN;

Line 5903: IF (utl_file.is_open(l_target_file)) THEN

5899: WSH_UTIL_CORE.add_message(x_return_status);
5900: --
5901: -- Close the file
5902: --
5903: IF (utl_file.is_open(l_target_file)) THEN
5904: utl_file.fclose(l_target_file);
5905: END IF;
5906:
5907: --

Line 5904: utl_file.fclose(l_target_file);

5900: --
5901: -- Close the file
5902: --
5903: IF (utl_file.is_open(l_target_file)) THEN
5904: utl_file.fclose(l_target_file);
5905: END IF;
5906:
5907: --
5908: -- Close cursors

Line 5959: IF (utl_file.is_open(l_target_file)) THEN

5955: WSH_UTIL_CORE.add_message(x_return_status);
5956: --
5957: -- Close the file
5958: --
5959: IF (utl_file.is_open(l_target_file)) THEN
5960: utl_file.fclose(l_target_file);
5961: END IF;
5962:
5963: --

Line 5960: utl_file.fclose(l_target_file);

5956: --
5957: -- Close the file
5958: --
5959: IF (utl_file.is_open(l_target_file)) THEN
5960: utl_file.fclose(l_target_file);
5961: END IF;
5962:
5963: --
5964: -- Close cursors

Line 6015: IF (utl_file.is_open(l_target_file)) THEN

6011: WSH_UTIL_CORE.add_message(x_return_status);
6012: --
6013: -- Close the file
6014: --
6015: IF (utl_file.is_open(l_target_file)) THEN
6016: utl_file.fclose(l_target_file);
6017: END IF;
6018: --
6019: -- Close cursors

Line 6016: utl_file.fclose(l_target_file);

6012: --
6013: -- Close the file
6014: --
6015: IF (utl_file.is_open(l_target_file)) THEN
6016: utl_file.fclose(l_target_file);
6017: END IF;
6018: --
6019: -- Close cursors
6020: --

Line 6071: IF (utl_file.is_open(l_target_file)) THEN

6067: WSH_UTIL_CORE.add_message(x_return_status);
6068: --
6069: -- Close the file
6070: --
6071: IF (utl_file.is_open(l_target_file)) THEN
6072: utl_file.fclose(l_target_file);
6073: END IF;
6074: --
6075: -- Close cursors

Line 6072: utl_file.fclose(l_target_file);

6068: --
6069: -- Close the file
6070: --
6071: IF (utl_file.is_open(l_target_file)) THEN
6072: utl_file.fclose(l_target_file);
6073: END IF;
6074: --
6075: -- Close cursors
6076: --

Line 6126: IF (utl_file.is_open(l_target_file)) THEN

6122: WSH_UTIL_CORE.add_message(x_return_status);
6123: --
6124: -- Close the file
6125: --
6126: IF (utl_file.is_open(l_target_file)) THEN
6127: utl_file.fclose(l_target_file);
6128: END IF;
6129: --
6130: -- Close cursors

Line 6127: utl_file.fclose(l_target_file);

6123: --
6124: -- Close the file
6125: --
6126: IF (utl_file.is_open(l_target_file)) THEN
6127: utl_file.fclose(l_target_file);
6128: END IF;
6129: --
6130: -- Close cursors
6131: --

Line 6183: IF (utl_file.is_open(l_target_file)) THEN

6179: WSH_UTIL_CORE.add_message(x_return_status);
6180: --
6181: -- Close the file
6182: --
6183: IF (utl_file.is_open(l_target_file)) THEN
6184: utl_file.fclose(l_target_file);
6185: END IF;
6186: --
6187: -- Close cursors

Line 6184: utl_file.fclose(l_target_file);

6180: --
6181: -- Close the file
6182: --
6183: IF (utl_file.is_open(l_target_file)) THEN
6184: utl_file.fclose(l_target_file);
6185: END IF;
6186: --
6187: -- Close cursors
6188: --

Line 6238: IF (utl_file.is_open(l_target_file)) THEN

6234: WSH_UTIL_CORE.add_message(x_return_status);
6235: --
6236: -- Close the file
6237: --
6238: IF (utl_file.is_open(l_target_file)) THEN
6239: utl_file.fclose(l_target_file);
6240: END IF;
6241: --
6242: -- Close cursors

Line 6239: utl_file.fclose(l_target_file);

6235: --
6236: -- Close the file
6237: --
6238: IF (utl_file.is_open(l_target_file)) THEN
6239: utl_file.fclose(l_target_file);
6240: END IF;
6241: --
6242: -- Close cursors
6243: --

Line 6292: IF (utl_file.is_open(l_target_file)) THEN

6288: WSH_UTIL_CORE.add_message(x_return_status);
6289: --
6290: -- Close the file
6291: --
6292: IF (utl_file.is_open(l_target_file)) THEN
6293: utl_file.fclose(l_target_file);
6294: END IF;
6295: --
6296: -- Close cursors

Line 6293: utl_file.fclose(l_target_file);

6289: --
6290: -- Close the file
6291: --
6292: IF (utl_file.is_open(l_target_file)) THEN
6293: utl_file.fclose(l_target_file);
6294: END IF;
6295: --
6296: -- Close cursors
6297: --

Line 6346: IF (utl_file.is_open(l_target_file)) THEN

6342: WSH_UTIL_CORE.add_message(x_return_status);
6343: --
6344: -- Close the file
6345: --
6346: IF (utl_file.is_open(l_target_file)) THEN
6347: utl_file.fclose(l_target_file);
6348: END IF;
6349: --
6350: -- Close cursors

Line 6347: utl_file.fclose(l_target_file);

6343: --
6344: -- Close the file
6345: --
6346: IF (utl_file.is_open(l_target_file)) THEN
6347: utl_file.fclose(l_target_file);
6348: END IF;
6349: --
6350: -- Close cursors
6351: --

Line 6399: IF (utl_file.is_open(l_target_file)) THEN

6395:
6396: --
6397: -- Close the file
6398: --
6399: IF (utl_file.is_open(l_target_file)) THEN
6400: utl_file.fclose(l_target_file);
6401: END IF;
6402:
6403:

Line 6400: utl_file.fclose(l_target_file);

6396: --
6397: -- Close the file
6398: --
6399: IF (utl_file.is_open(l_target_file)) THEN
6400: utl_file.fclose(l_target_file);
6401: END IF;
6402:
6403:
6404: --