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

Line 5017: v_file UTL_FILE.file_type; -- output file handle

5013: , x_msg_data OUT NOCOPY VARCHAR2
5014: ) IS
5015: -- variables
5016: l_api_name VARCHAR2(30) := 'EXPORT_FILE';
5017: v_file UTL_FILE.file_type; -- output file handle
5018: v_start NUMBER := p_task_table.FIRST;
5019: v_end NUMBER := p_task_table.LAST;
5020: v_cnt NUMBER;
5021: v_tab CONSTANT VARCHAR2(1) := fnd_global.local_chr(9); --tab value 9 in ascii

Line 5025: UTL_FILE.putf(v_file, p_str || v_tab);

5021: v_tab CONSTANT VARCHAR2(1) := fnd_global.local_chr(9); --tab value 9 in ascii
5022:
5023: PROCEDURE put_f_out(p_str IN VARCHAR2) IS
5024: BEGIN
5025: UTL_FILE.putf(v_file, p_str || v_tab);
5026: END put_f_out;
5027:
5028: PROCEDURE put_f(p_in IN VARCHAR2) IS
5029: BEGIN

Line 5054: IF (UTL_FILE.is_open(v_file)) THEN

5050: BEGIN -- export file
5051: x_return_status := fnd_api.g_ret_sts_success;
5052:
5053: -- close file if its open
5054: IF (UTL_FILE.is_open(v_file)) THEN
5055: UTL_FILE.fclose(v_file);
5056: END IF;
5057:
5058: -- open file for write only

Line 5055: UTL_FILE.fclose(v_file);

5051: x_return_status := fnd_api.g_ret_sts_success;
5052:
5053: -- close file if its open
5054: IF (UTL_FILE.is_open(v_file)) THEN
5055: UTL_FILE.fclose(v_file);
5056: END IF;
5057:
5058: -- open file for write only
5059: v_file := UTL_FILE.fopen(p_path, p_file_name, 'w');

Line 5059: v_file := UTL_FILE.fopen(p_path, p_file_name, 'w');

5055: UTL_FILE.fclose(v_file);
5056: END IF;
5057:
5058: -- open file for write only
5059: v_file := UTL_FILE.fopen(p_path, p_file_name, 'w');
5060:
5061: FOR v_cnt IN v_start .. v_end LOOP
5062: put_f(p_task_table(v_cnt).task_id);
5063: put_f(p_task_table(v_cnt).task_number);

Line 5078: UTL_FILE.new_line(v_file, 1);

5074: put_f(p_task_table(v_cnt).DURATION);
5075: put_f(p_task_table(v_cnt).duration_uom);
5076: put_f(p_task_table(v_cnt).planned_effort);
5077: put_f(p_task_table(v_cnt).planned_effort_uom);
5078: UTL_FILE.new_line(v_file, 1);
5079: END LOOP;
5080:
5081: -- close file
5082: UTL_FILE.fclose(v_file);

Line 5082: UTL_FILE.fclose(v_file);

5078: UTL_FILE.new_line(v_file, 1);
5079: END LOOP;
5080:
5081: -- close file
5082: UTL_FILE.fclose(v_file);
5083: EXCEPTION
5084: WHEN fnd_api.g_exc_error THEN
5085: IF (UTL_FILE.is_open(v_file)) THEN
5086: UTL_FILE.fclose(v_file);

Line 5085: IF (UTL_FILE.is_open(v_file)) THEN

5081: -- close file
5082: UTL_FILE.fclose(v_file);
5083: EXCEPTION
5084: WHEN fnd_api.g_exc_error THEN
5085: IF (UTL_FILE.is_open(v_file)) THEN
5086: UTL_FILE.fclose(v_file);
5087: END IF;
5088:
5089: x_return_status := fnd_api.g_ret_sts_error;

Line 5086: UTL_FILE.fclose(v_file);

5082: UTL_FILE.fclose(v_file);
5083: EXCEPTION
5084: WHEN fnd_api.g_exc_error THEN
5085: IF (UTL_FILE.is_open(v_file)) THEN
5086: UTL_FILE.fclose(v_file);
5087: END IF;
5088:
5089: x_return_status := fnd_api.g_ret_sts_error;
5090: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 5092: IF (UTL_FILE.is_open(v_file)) THEN

5088:
5089: x_return_status := fnd_api.g_ret_sts_error;
5090: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5091: WHEN fnd_api.g_exc_unexpected_error THEN
5092: IF (UTL_FILE.is_open(v_file)) THEN
5093: UTL_FILE.fclose(v_file);
5094: END IF;
5095:
5096: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5093: UTL_FILE.fclose(v_file);

5089: x_return_status := fnd_api.g_ret_sts_error;
5090: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5091: WHEN fnd_api.g_exc_unexpected_error THEN
5092: IF (UTL_FILE.is_open(v_file)) THEN
5093: UTL_FILE.fclose(v_file);
5094: END IF;
5095:
5096: x_return_status := fnd_api.g_ret_sts_unexp_error;
5097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 5099: IF (UTL_FILE.is_open(v_file)) THEN

5095:
5096: x_return_status := fnd_api.g_ret_sts_unexp_error;
5097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5098: WHEN OTHERS THEN
5099: IF (UTL_FILE.is_open(v_file)) THEN
5100: UTL_FILE.fclose(v_file);
5101: END IF;
5102:
5103: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5100: UTL_FILE.fclose(v_file);

5096: x_return_status := fnd_api.g_ret_sts_unexp_error;
5097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5098: WHEN OTHERS THEN
5099: IF (UTL_FILE.is_open(v_file)) THEN
5100: UTL_FILE.fclose(v_file);
5101: END IF;
5102:
5103: x_return_status := fnd_api.g_ret_sts_unexp_error;
5104: