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

Line 887: l_file UTL_FILE.FILE_TYPE;

883: ---------------------------------------------------------
884: PROCEDURE WriteToFile(p_xml IN CLOB, p_file_dir IN VARCHAR2, p_file_name IN VARCHAR2) IS
885: l_xmlstr varchar2(32767);
886: l_line varchar2(2000);
887: l_file UTL_FILE.FILE_TYPE;
888: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
889: BEGIN
890: l_file := utl_file.fopen(rtrim(p_file_dir,'/'), p_file_name, 'w');
891: l_xmlstr := dbms_lob.substr(p_xml, 32767);

Line 890: l_file := utl_file.fopen(rtrim(p_file_dir,'/'), p_file_name, 'w');

886: l_line varchar2(2000);
887: l_file UTL_FILE.FILE_TYPE;
888: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
889: BEGIN
890: l_file := utl_file.fopen(rtrim(p_file_dir,'/'), p_file_name, 'w');
891: l_xmlstr := dbms_lob.substr(p_xml, 32767);
892: loop
893: exit when l_xmlstr is null;
894: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);

Line 895: utl_file.put_line(l_file, l_line);

891: l_xmlstr := dbms_lob.substr(p_xml, 32767);
892: loop
893: exit when l_xmlstr is null;
894: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);
895: utl_file.put_line(l_file, l_line);
896: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
897: end loop;
898: utl_file.fclose(l_file);
899: EXCEPTION

Line 898: utl_file.fclose(l_file);

894: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);
895: utl_file.put_line(l_file, l_line);
896: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
897: end loop;
898: utl_file.fclose(l_file);
899: EXCEPTION
900: WHEN utl_file.invalid_path THEN
901: IF (l_debug = 1) THEN
902: trace('Invalid path in WriteToFile: '||p_file_dir);

Line 900: WHEN utl_file.invalid_path THEN

896: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
897: end loop;
898: utl_file.fclose(l_file);
899: EXCEPTION
900: WHEN utl_file.invalid_path THEN
901: IF (l_debug = 1) THEN
902: trace('Invalid path in WriteToFile: '||p_file_dir);
903: END IF;
904: WHEN utl_file.invalid_mode THEN

Line 904: WHEN utl_file.invalid_mode THEN

900: WHEN utl_file.invalid_path THEN
901: IF (l_debug = 1) THEN
902: trace('Invalid path in WriteToFile: '||p_file_dir);
903: END IF;
904: WHEN utl_file.invalid_mode THEN
905: IF (l_debug = 1) THEN
906: trace('Invalid mode in WriteToFile: w');
907: END IF;
908: WHEN fnd_api.g_exc_error THEN

Line 1014: l_file UTL_FILE.FILE_TYPE;

1010: l_file_prefix VARCHAR2(50);
1011: l_seq_id NUMBER;
1012: l_file_name VARCHAR2(50);
1013:
1014: l_file UTL_FILE.FILE_TYPE;
1015:
1016: l_csv_column_list VARCHAR2(200) :=
1017: 'DEVICE,REQUESTID,TASKTYPE,BUSINESSEVENT,TASKID,SEQUENCEID,RELATIONID,ORG,SUB,'||'LOC,TRANSFERORG,TRANSFERSUB,TRANSFERLOC,LPN,XFERLPN,ITEM,REVISION,QUANTITY,UOM,LOT,LOTQTY,SERIAL,ERRORCODE,TIMESTAMP'; --Added for Bug#8512121
1018:

Line 1104: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');

1100: trace('Result will be saved in '||l_file_dir||'/'||l_file_name);
1101: END IF;
1102:
1103: --OPEN FILE
1104: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1105: UTL_FILE.PUT_LINE(l_file, XML_HEADER);
1106: UTL_FILE.PUT_LINE(l_file, DEVICEH_TB || ' name="' || l_dev_name ||'"'
1107: || ' request_id="' || l_seq_id || '"'|| TAG_E);
1108: IF (l_debug = 1) THEN

Line 1105: UTL_FILE.PUT_LINE(l_file, XML_HEADER);

1101: END IF;
1102:
1103: --OPEN FILE
1104: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1105: UTL_FILE.PUT_LINE(l_file, XML_HEADER);
1106: UTL_FILE.PUT_LINE(l_file, DEVICEH_TB || ' name="' || l_dev_name ||'"'
1107: || ' request_id="' || l_seq_id || '"'|| TAG_E);
1108: IF (l_debug = 1) THEN
1109: trace('Opening xml cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);

Line 1106: UTL_FILE.PUT_LINE(l_file, DEVICEH_TB || ' name="' || l_dev_name ||'"'

1102:
1103: --OPEN FILE
1104: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1105: UTL_FILE.PUT_LINE(l_file, XML_HEADER);
1106: UTL_FILE.PUT_LINE(l_file, DEVICEH_TB || ' name="' || l_dev_name ||'"'
1107: || ' request_id="' || l_seq_id || '"'|| TAG_E);
1108: IF (l_debug = 1) THEN
1109: trace('Opening xml cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);
1110: END IF;

Line 1149: UTL_FILE.PUT_LINE(l_file, TASK_TB);

1145: END IF;
1146:
1147:
1148:
1149: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1150: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1151: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1152: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);

Line 1150: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);

1146:
1147:
1148:
1149: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1150: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1151: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1152: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);

Line 1151: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);

1147:
1148:
1149: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1150: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1151: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1152: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);

Line 1152: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);

1148:
1149: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1150: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1151: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1152: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);

Line 1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);

1149: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1150: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1151: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1152: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);

Line 1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);

1150: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1151: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1152: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);

Line 1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);

1151: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1152: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);

Line 1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);

1152: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);

Line 1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);

1153: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);

Line 1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);

1154: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);

Line 1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);

1155: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);

Line 1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);

1156: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121

Line 1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);

1157: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121
1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);

Line 1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);

1158: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121
1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);

Line 1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);

1159: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121
1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);

Line 1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121

1160: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121
1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);

Line 1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);

1161: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121
1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);

Line 1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);

1162: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121
1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);

Line 1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);

1163: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121
1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);

Line 1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);

1164: UTL_FILE.PUT_LINE(l_file, XFERLPN_TB||v_xml.XFERLPNID ||XFERLPN_TE); --Added for Bug#8512121
1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1172: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);

Line 1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);

1165: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1172: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1173: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);

Line 1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);

1166: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1172: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1173: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1174: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);

Line 1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);

1167: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1172: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1173: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1174: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1175: UTL_FILE.PUT_LINE(l_file, TASK_TE);

Line 1172: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);

1168: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1172: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1173: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1174: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1175: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1176: END LOOP;

Line 1173: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);

1169: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1172: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1173: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1174: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1175: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1176: END LOOP;
1177: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);

Line 1174: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);

1170: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1172: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1173: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1174: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1175: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1176: END LOOP;
1177: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);
1178: UTL_FILE.fclose(l_file);

Line 1175: UTL_FILE.PUT_LINE(l_file, TASK_TE);

1171: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1172: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1173: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1174: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1175: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1176: END LOOP;
1177: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);
1178: UTL_FILE.fclose(l_file);
1179: IF (l_debug = 1) THEN

Line 1177: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);

1173: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1174: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1175: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1176: END LOOP;
1177: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);
1178: UTL_FILE.fclose(l_file);
1179: IF (l_debug = 1) THEN
1180: trace(' File created ');
1181: END IF;

Line 1178: UTL_FILE.fclose(l_file);

1174: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1175: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1176: END LOOP;
1177: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);
1178: UTL_FILE.fclose(l_file);
1179: IF (l_debug = 1) THEN
1180: trace(' File created ');
1181: END IF;
1182:

Line 1192: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');

1188: END IF;
1189: l_seperator := ',';
1190:
1191: -- OPEN FILE
1192: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1193: UTL_FILE.PUT_LINE(l_file, l_csv_column_list);
1194: IF (l_debug = 1) THEN
1195: trace('Opening csv cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);
1196: END IF;

Line 1193: UTL_FILE.PUT_LINE(l_file, l_csv_column_list);

1189: l_seperator := ',';
1190:
1191: -- OPEN FILE
1192: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1193: UTL_FILE.PUT_LINE(l_file, l_csv_column_list);
1194: IF (l_debug = 1) THEN
1195: trace('Opening csv cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);
1196: END IF;
1197: FOR v_csv IN csv_cur(p_device_id, l_task_sum) LOOP

Line 1198: UTL_FILE.PUT_LINE(l_file, v_csv.csv_line);

1194: IF (l_debug = 1) THEN
1195: trace('Opening csv cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);
1196: END IF;
1197: FOR v_csv IN csv_cur(p_device_id, l_task_sum) LOOP
1198: UTL_FILE.PUT_LINE(l_file, v_csv.csv_line);
1199: END LOOP;
1200:
1201: UTL_FILE.fclose(l_file);
1202: IF (l_debug = 1) THEN

Line 1201: UTL_FILE.fclose(l_file);

1197: FOR v_csv IN csv_cur(p_device_id, l_task_sum) LOOP
1198: UTL_FILE.PUT_LINE(l_file, v_csv.csv_line);
1199: END LOOP;
1200:
1201: UTL_FILE.fclose(l_file);
1202: IF (l_debug = 1) THEN
1203: trace(' File created ');
1204: END IF;
1205: ELSE

Line 1223: WHEN utl_file.invalid_path THEN

1219: AND nvl(task_summary, 'Y') = decode(l_lot_serial_enabled,'N','Y','Y',nvl(task_summary,'Y'),'Y');
1220:
1221: return retval;
1222: EXCEPTION
1223: WHEN utl_file.invalid_path THEN
1224: IF (l_debug = 1) THEN
1225: trace('Invalid Path error in generate_xml_csv');
1226: END IF;
1227: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');

Line 1232: WHEN utl_file.invalid_mode THEN

1228: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Path');
1229: FND_MSG_PUB.ADD;
1230: retval := -1;
1231: return retval;
1232: WHEN utl_file.invalid_mode THEN
1233: IF (l_debug = 1) THEN
1234: trace('Invalid mode in generate_xml_csv: w');
1235: END IF;
1236: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');