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 4936: v_file UTL_FILE.file_type; -- output file handle

4932: , x_msg_data OUT NOCOPY VARCHAR2
4933: ) IS
4934: -- variables
4935: l_api_name VARCHAR2(30) := 'EXPORT_FILE';
4936: v_file UTL_FILE.file_type; -- output file handle
4937: v_start NUMBER := p_task_table.FIRST;
4938: v_end NUMBER := p_task_table.LAST;
4939: v_cnt NUMBER;
4940: v_tab CONSTANT VARCHAR2(1) := fnd_global.local_chr(9); --tab value 9 in ascii

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

4940: v_tab CONSTANT VARCHAR2(1) := fnd_global.local_chr(9); --tab value 9 in ascii
4941:
4942: PROCEDURE put_f_out(p_str IN VARCHAR2) IS
4943: BEGIN
4944: UTL_FILE.putf(v_file, p_str || v_tab);
4945: END put_f_out;
4946:
4947: PROCEDURE put_f(p_in IN VARCHAR2) IS
4948: BEGIN

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

4969: BEGIN -- export file
4970: x_return_status := fnd_api.g_ret_sts_success;
4971:
4972: -- close file if its open
4973: IF (UTL_FILE.is_open(v_file)) THEN
4974: UTL_FILE.fclose(v_file);
4975: END IF;
4976:
4977: -- open file for write only

Line 4974: UTL_FILE.fclose(v_file);

4970: x_return_status := fnd_api.g_ret_sts_success;
4971:
4972: -- close file if its open
4973: IF (UTL_FILE.is_open(v_file)) THEN
4974: UTL_FILE.fclose(v_file);
4975: END IF;
4976:
4977: -- open file for write only
4978: v_file := UTL_FILE.fopen(p_path, p_file_name, 'w');

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

4974: UTL_FILE.fclose(v_file);
4975: END IF;
4976:
4977: -- open file for write only
4978: v_file := UTL_FILE.fopen(p_path, p_file_name, 'w');
4979:
4980: FOR v_cnt IN v_start .. v_end LOOP
4981: put_f(p_task_table(v_cnt).task_id);
4982: put_f(p_task_table(v_cnt).task_number);

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

4993: put_f(p_task_table(v_cnt).DURATION);
4994: put_f(p_task_table(v_cnt).duration_uom);
4995: put_f(p_task_table(v_cnt).planned_effort);
4996: put_f(p_task_table(v_cnt).planned_effort_uom);
4997: UTL_FILE.new_line(v_file, 1);
4998: END LOOP;
4999:
5000: -- close file
5001: UTL_FILE.fclose(v_file);

Line 5001: UTL_FILE.fclose(v_file);

4997: UTL_FILE.new_line(v_file, 1);
4998: END LOOP;
4999:
5000: -- close file
5001: UTL_FILE.fclose(v_file);
5002: EXCEPTION
5003: WHEN fnd_api.g_exc_error THEN
5004: IF (UTL_FILE.is_open(v_file)) THEN
5005: UTL_FILE.fclose(v_file);

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

5000: -- close file
5001: UTL_FILE.fclose(v_file);
5002: EXCEPTION
5003: WHEN fnd_api.g_exc_error THEN
5004: IF (UTL_FILE.is_open(v_file)) THEN
5005: UTL_FILE.fclose(v_file);
5006: END IF;
5007:
5008: x_return_status := fnd_api.g_ret_sts_error;

Line 5005: UTL_FILE.fclose(v_file);

5001: UTL_FILE.fclose(v_file);
5002: EXCEPTION
5003: WHEN fnd_api.g_exc_error THEN
5004: IF (UTL_FILE.is_open(v_file)) THEN
5005: UTL_FILE.fclose(v_file);
5006: END IF;
5007:
5008: x_return_status := fnd_api.g_ret_sts_error;
5009: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5007:
5008: x_return_status := fnd_api.g_ret_sts_error;
5009: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5010: WHEN fnd_api.g_exc_unexpected_error THEN
5011: IF (UTL_FILE.is_open(v_file)) THEN
5012: UTL_FILE.fclose(v_file);
5013: END IF;
5014:
5015: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5012: UTL_FILE.fclose(v_file);

5008: x_return_status := fnd_api.g_ret_sts_error;
5009: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5010: WHEN fnd_api.g_exc_unexpected_error THEN
5011: IF (UTL_FILE.is_open(v_file)) THEN
5012: UTL_FILE.fclose(v_file);
5013: END IF;
5014:
5015: x_return_status := fnd_api.g_ret_sts_unexp_error;
5016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5014:
5015: x_return_status := fnd_api.g_ret_sts_unexp_error;
5016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5017: WHEN OTHERS THEN
5018: IF (UTL_FILE.is_open(v_file)) THEN
5019: UTL_FILE.fclose(v_file);
5020: END IF;
5021:
5022: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5019: UTL_FILE.fclose(v_file);

5015: x_return_status := fnd_api.g_ret_sts_unexp_error;
5016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5017: WHEN OTHERS THEN
5018: IF (UTL_FILE.is_open(v_file)) THEN
5019: UTL_FILE.fclose(v_file);
5020: END IF;
5021:
5022: x_return_status := fnd_api.g_ret_sts_unexp_error;
5023: