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 867: l_file UTL_FILE.FILE_TYPE;

863: ---------------------------------------------------------
864: PROCEDURE WriteToFile(p_xml IN CLOB, p_file_dir IN VARCHAR2, p_file_name IN VARCHAR2) IS
865: l_xmlstr varchar2(32767);
866: l_line varchar2(2000);
867: l_file UTL_FILE.FILE_TYPE;
868: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
869: BEGIN
870: l_file := utl_file.fopen(rtrim(p_file_dir,'/'), p_file_name, 'w');
871: l_xmlstr := dbms_lob.substr(p_xml, 32767);

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

866: l_line varchar2(2000);
867: l_file UTL_FILE.FILE_TYPE;
868: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
869: BEGIN
870: l_file := utl_file.fopen(rtrim(p_file_dir,'/'), p_file_name, 'w');
871: l_xmlstr := dbms_lob.substr(p_xml, 32767);
872: loop
873: exit when l_xmlstr is null;
874: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);

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

871: l_xmlstr := dbms_lob.substr(p_xml, 32767);
872: loop
873: exit when l_xmlstr is null;
874: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);
875: utl_file.put_line(l_file, l_line);
876: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
877: end loop;
878: utl_file.fclose(l_file);
879: EXCEPTION

Line 878: utl_file.fclose(l_file);

874: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);
875: utl_file.put_line(l_file, l_line);
876: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
877: end loop;
878: utl_file.fclose(l_file);
879: EXCEPTION
880: WHEN utl_file.invalid_path THEN
881: IF (l_debug = 1) THEN
882: trace('Invalid path in WriteToFile: '||p_file_dir);

Line 880: WHEN utl_file.invalid_path THEN

876: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
877: end loop;
878: utl_file.fclose(l_file);
879: EXCEPTION
880: WHEN utl_file.invalid_path THEN
881: IF (l_debug = 1) THEN
882: trace('Invalid path in WriteToFile: '||p_file_dir);
883: END IF;
884: WHEN utl_file.invalid_mode THEN

Line 884: WHEN utl_file.invalid_mode THEN

880: WHEN utl_file.invalid_path THEN
881: IF (l_debug = 1) THEN
882: trace('Invalid path in WriteToFile: '||p_file_dir);
883: END IF;
884: WHEN utl_file.invalid_mode THEN
885: IF (l_debug = 1) THEN
886: trace('Invalid mode in WriteToFile: w');
887: END IF;
888: WHEN fnd_api.g_exc_error THEN

Line 993: l_file UTL_FILE.FILE_TYPE;

989: l_file_prefix VARCHAR2(50);
990: l_seq_id NUMBER;
991: l_file_name VARCHAR2(50);
992:
993: l_file UTL_FILE.FILE_TYPE;
994:
995: l_csv_column_list VARCHAR2(200) :=
996: 'DEVICE,REQUESTID,TASKTYPE,BUSINESSEVENT,TASKID,SEQUENCEID,RELATIONID,ORG,SUB,'||'LOC,TRANSFERORG,TRANSFERSUB,TRANSFERLOC,LPN,ITEM,REVISION,QUANTITY,UOM,LOT,LOTQTY,SERIAL,ERRORCODE,TIMESTAMP';
997:

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

1079: trace('Result will be saved in '||l_file_dir||'/'||l_file_name);
1080: END IF;
1081:
1082: --OPEN FILE
1083: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1084: UTL_FILE.PUT_LINE(l_file, XML_HEADER);
1085: UTL_FILE.PUT_LINE(l_file, DEVICEH_TB || ' name="' || l_dev_name ||'"'
1086: || ' request_id="' || l_seq_id || '"'|| TAG_E);
1087: IF (l_debug = 1) THEN

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

1080: END IF;
1081:
1082: --OPEN FILE
1083: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1084: UTL_FILE.PUT_LINE(l_file, XML_HEADER);
1085: UTL_FILE.PUT_LINE(l_file, DEVICEH_TB || ' name="' || l_dev_name ||'"'
1086: || ' request_id="' || l_seq_id || '"'|| TAG_E);
1087: IF (l_debug = 1) THEN
1088: trace('Opening xml cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);

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

1081:
1082: --OPEN FILE
1083: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1084: UTL_FILE.PUT_LINE(l_file, XML_HEADER);
1085: UTL_FILE.PUT_LINE(l_file, DEVICEH_TB || ' name="' || l_dev_name ||'"'
1086: || ' request_id="' || l_seq_id || '"'|| TAG_E);
1087: IF (l_debug = 1) THEN
1088: trace('Opening xml cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);
1089: END IF;

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

1124: END IF;
1125:
1126:
1127:
1128: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1129: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1130: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1131: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1132: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);

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

1125:
1126:
1127:
1128: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1129: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1130: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1131: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1132: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1133: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);

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

1126:
1127:
1128: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1129: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1130: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1131: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1132: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1133: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1134: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);

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

1127:
1128: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1129: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1130: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1131: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1132: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1133: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1134: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1135: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);

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

1128: UTL_FILE.PUT_LINE(l_file, TASK_TB);
1129: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1130: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1131: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1132: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1133: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1134: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1135: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1136: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);

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

1129: UTL_FILE.PUT_LINE(l_file, DEVICE_TB|| v_xml.DEVICE ||DEVICE_TE);
1130: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1131: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1132: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1133: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1134: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1135: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1136: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1137: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);

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

1130: UTL_FILE.PUT_LINE(l_file, REQUESTID_TB|| v_xml.REQUESTID||REQUESTID_TE);
1131: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1132: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1133: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1134: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1135: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1136: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1137: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1138: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);

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

1131: UTL_FILE.PUT_LINE(l_file, TASKTYPE_TB|| v_xml.TASKTYPE||TASKTYPE_TE);
1132: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1133: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1134: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1135: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1136: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1137: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1138: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1139: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);

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

1132: UTL_FILE.PUT_LINE(l_file, BUSINESSEVENT_TB||v_xml.BUSINESSEVENT ||BUSINESSEVENT_TE);
1133: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1134: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1135: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1136: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1137: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1138: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1139: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1140: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);

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

1133: UTL_FILE.PUT_LINE(l_file, TASKID_TB|| v_xml.TASKID||TASKID_TE);
1134: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1135: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1136: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1137: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1138: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1139: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1140: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1141: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);

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

1134: UTL_FILE.PUT_LINE(l_file, SEQUENCEID_TB|| v_xml.SEQUENCEID||SEQUENCEID_TE);
1135: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1136: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1137: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1138: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1139: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1140: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1141: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1142: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);

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

1135: UTL_FILE.PUT_LINE(l_file, RELATIONID_TB|| v_xml.RELATIONID||RELATIONID_TE);
1136: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1137: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1138: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1139: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1140: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1141: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1142: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1143: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);

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

1136: UTL_FILE.PUT_LINE(l_file, ORG_TB|| v_xml.ORG||ORG_TE);
1137: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1138: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1139: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1140: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1141: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1142: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1143: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1144: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);

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

1137: UTL_FILE.PUT_LINE(l_file, SUB_TB|| v_xml.SUB||SUB_TE);
1138: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1139: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1140: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1141: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1142: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1143: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1144: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1145: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);

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

1138: UTL_FILE.PUT_LINE(l_file, LOC_TB||v_xml.LOC ||LOC_TE);
1139: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1140: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1141: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1142: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1143: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1144: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1145: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1146: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);

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

1139: UTL_FILE.PUT_LINE(l_file, TRANSFERORG_TB|| v_xml.TRANSFERORG||TRANSFERORG_TE);
1140: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1141: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1142: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1143: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1144: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1145: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1146: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1147: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);

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

1140: UTL_FILE.PUT_LINE(l_file, TRANSFERSUB_TB|| v_xml.TRANSFERSUB||TRANSFERSUB_TE);
1141: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1142: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1143: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1144: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1145: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1146: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1147: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1148: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);

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

1141: UTL_FILE.PUT_LINE(l_file, TRANSFERLOC_TB|| v_xml.TRANSFERLOC||TRANSFERLOC_TE);
1142: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1143: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1144: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1145: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1146: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1147: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1148: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1149: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);

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

1142: UTL_FILE.PUT_LINE(l_file, LPN_TB||v_xml.LPN ||LPN_TE);
1143: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1144: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1145: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1146: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1147: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1148: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1149: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1150: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);

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

1143: UTL_FILE.PUT_LINE(l_file, ITEM_TB||v_xml.ITEM ||ITEM_TE);
1144: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1145: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1146: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1147: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1148: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1149: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1150: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1151: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);

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

1144: UTL_FILE.PUT_LINE(l_file, REVISION_TB|| v_xml.REVISION||REVISION_TE);
1145: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1146: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1147: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1148: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1149: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1150: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1151: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1152: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);

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

1145: UTL_FILE.PUT_LINE(l_file, QUANTITY_TB|| v_xml.QUANTITY||QUANTITY_TE);
1146: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1147: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1148: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1149: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1150: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1151: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1152: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1153: UTL_FILE.PUT_LINE(l_file, TASK_TE);

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

1146: UTL_FILE.PUT_LINE(l_file, UOM_TB|| v_xml.UOM||UOM_TE);
1147: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1148: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1149: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1150: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1151: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1152: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1153: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1154: END LOOP;

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

1147: UTL_FILE.PUT_LINE(l_file, LOT_TB|| v_xml.LOT||LOT_TE);
1148: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1149: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1150: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1151: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1152: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1153: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1154: END LOOP;
1155: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);

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

1148: UTL_FILE.PUT_LINE(l_file, LOTQTY_TB|| v_xml.LOTQTY||LOTQTY_TE);
1149: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1150: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1151: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1152: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1153: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1154: END LOOP;
1155: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);
1156: UTL_FILE.fclose(l_file);

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

1149: UTL_FILE.PUT_LINE(l_file, SERIAL_TB|| v_xml.SERIAL||SERIAL_TE);
1150: UTL_FILE.PUT_LINE(l_file, SO_TB|| l_order_num||SO_TE);
1151: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1152: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1153: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1154: END LOOP;
1155: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);
1156: UTL_FILE.fclose(l_file);
1157: IF (l_debug = 1) THEN

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

1151: UTL_FILE.PUT_LINE(l_file, ERRORCODE_TB|| v_xml.STATUSMSG||ERRORCODE_TE);
1152: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1153: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1154: END LOOP;
1155: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);
1156: UTL_FILE.fclose(l_file);
1157: IF (l_debug = 1) THEN
1158: trace(' File created ');
1159: END IF;

Line 1156: UTL_FILE.fclose(l_file);

1152: UTL_FILE.PUT_LINE(l_file, TIMESTAMP_TB|| v_xml.TIMESTAMP||TIMESTAMP_TE);
1153: UTL_FILE.PUT_LINE(l_file, TASK_TE);
1154: END LOOP;
1155: UTL_FILE.PUT_LINE(l_file, DEVICE_TE);
1156: UTL_FILE.fclose(l_file);
1157: IF (l_debug = 1) THEN
1158: trace(' File created ');
1159: END IF;
1160:

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

1166: END IF;
1167: l_seperator := ',';
1168:
1169: -- OPEN FILE
1170: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1171: UTL_FILE.PUT_LINE(l_file, l_csv_column_list);
1172: IF (l_debug = 1) THEN
1173: trace('Opening csv cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);
1174: END IF;

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

1167: l_seperator := ',';
1168:
1169: -- OPEN FILE
1170: l_file := UTL_FILE.FOPEN(l_file_dir, l_file_name, 'w');
1171: UTL_FILE.PUT_LINE(l_file, l_csv_column_list);
1172: IF (l_debug = 1) THEN
1173: trace('Opening csv cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);
1174: END IF;
1175: FOR v_csv IN csv_cur(p_device_id, l_task_sum) LOOP

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

1172: IF (l_debug = 1) THEN
1173: trace('Opening csv cursor with dev_id='||p_device_id||',task_sum='||l_task_sum);
1174: END IF;
1175: FOR v_csv IN csv_cur(p_device_id, l_task_sum) LOOP
1176: UTL_FILE.PUT_LINE(l_file, v_csv.csv_line);
1177: END LOOP;
1178:
1179: UTL_FILE.fclose(l_file);
1180: IF (l_debug = 1) THEN

Line 1179: UTL_FILE.fclose(l_file);

1175: FOR v_csv IN csv_cur(p_device_id, l_task_sum) LOOP
1176: UTL_FILE.PUT_LINE(l_file, v_csv.csv_line);
1177: END LOOP;
1178:
1179: UTL_FILE.fclose(l_file);
1180: IF (l_debug = 1) THEN
1181: trace(' File created ');
1182: END IF;
1183: ELSE

Line 1201: WHEN utl_file.invalid_path THEN

1197: AND nvl(task_summary, 'Y') = decode(l_lot_serial_enabled,'N','Y','Y',nvl(task_summary,'Y'),'Y');
1198:
1199: return retval;
1200: EXCEPTION
1201: WHEN utl_file.invalid_path THEN
1202: IF (l_debug = 1) THEN
1203: trace('Invalid Path error in generate_xml_csv');
1204: END IF;
1205: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');

Line 1210: WHEN utl_file.invalid_mode THEN

1206: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Path');
1207: FND_MSG_PUB.ADD;
1208: retval := -1;
1209: return retval;
1210: WHEN utl_file.invalid_mode THEN
1211: IF (l_debug = 1) THEN
1212: trace('Invalid mode in generate_xml_csv: w');
1213: END IF;
1214: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');