APPS.WMS_CLABEL dependencies on UTL_FILE

Line 16: xmlfh UTL_FILE.FILE_TYPE := NULL;

12: labelName VARCHAR2(50);
13: printerName VARCHAR2(40);
14: noCopies NUMBER;
15:
16: xmlfh UTL_FILE.FILE_TYPE := NULL;
17:
18: header VARIABLES_TYPE;
19: line VARIABLES_TYPE;
20:

Line 87: xmlfh := utl_file.fopen(p_dir,p_file,'w');

83: PROCEDURE openLabelFile(p_dir IN VARCHAR2,p_file IN VARCHAR2)
84: IS
85: l_labels VARCHAR2(200) := ' 86: BEGIN
87: xmlfh := utl_file.fopen(p_dir,p_file,'w');
88: utl_file.put_line(xmlfh,XML_HEADER1);
89: utl_file.put_line(xmlfh,XML_HEADER2);
90:
91: if defaultLabelName IS NOT NULL then

Line 88: utl_file.put_line(xmlfh,XML_HEADER1);

84: IS
85: l_labels VARCHAR2(200) := ' 86: BEGIN
87: xmlfh := utl_file.fopen(p_dir,p_file,'w');
88: utl_file.put_line(xmlfh,XML_HEADER1);
89: utl_file.put_line(xmlfh,XML_HEADER2);
90:
91: if defaultLabelName IS NOT NULL then
92: l_labels := l_labels||' defaultLabelName="'||defaultLabelName||'"';

Line 89: utl_file.put_line(xmlfh,XML_HEADER2);

85: l_labels VARCHAR2(200) := ' 86: BEGIN
87: xmlfh := utl_file.fopen(p_dir,p_file,'w');
88: utl_file.put_line(xmlfh,XML_HEADER1);
89: utl_file.put_line(xmlfh,XML_HEADER2);
90:
91: if defaultLabelName IS NOT NULL then
92: l_labels := l_labels||' defaultLabelName="'||defaultLabelName||'"';
93: end if;

Line 102: utl_file.put_line(xmlfh,l_labels);

98: l_labels := l_labels||' defaultNoCopies="'||defaultNoCopies||'"';
99: end if;
100:
101: l_labels := l_labels||'>';
102: utl_file.put_line(xmlfh,l_labels);
103: EXCEPTION
104: WHEN UTL_FILE.INVALID_PATH THEN
105: null;
106: WHEN OTHERS THEN

Line 104: WHEN UTL_FILE.INVALID_PATH THEN

100:
101: l_labels := l_labels||'>';
102: utl_file.put_line(xmlfh,l_labels);
103: EXCEPTION
104: WHEN UTL_FILE.INVALID_PATH THEN
105: null;
106: WHEN OTHERS THEN
107: null;
108: END openLabelFile;

Line 122: utl_file.put_line(xmlfh,''||

118: l_var_name := substr(l_var_value_pair,1,
119: instr(l_var_value_pair,separator)-1);
120: l_var_value := substr(l_var_value_pair,
121: instr(l_var_value_pair,separator)+length(separator));
122: utl_file.put_line(xmlfh,''||
123: l_var_value||'');
124: end loop;
125: END writeVariables;
126:

Line 141: utl_file.put_line(xmlfh,l_label);

137: if noCopies IS NOT NULL then
138: l_label := l_label||' noCopies="'||noCopies||'"';
139: end if;
140: l_label := l_label||'>';
141: utl_file.put_line(xmlfh,l_label);
142:
143: if(p_print_header = PRINT_WITH_HEADER) then
144: writeVariables(header);
145: end if;

Line 148: utl_file.put_line(xmlfh,'');

144: writeVariables(header);
145: end if;
146: writeVariables(line);
147:
148: utl_file.put_line(xmlfh,'');
149: END writeLabel;
150:
151: PROCEDURE closeLabelFile
152: IS

Line 154: utl_file.put_line(xmlfh,'');

150:
151: PROCEDURE closeLabelFile
152: IS
153: BEGIN
154: utl_file.put_line(xmlfh,'');
155: utl_file.fclose(xmlfh);
156: EXCEPTION
157: WHEN OTHERS THEN
158: null;

Line 155: utl_file.fclose(xmlfh);

151: PROCEDURE closeLabelFile
152: IS
153: BEGIN
154: utl_file.put_line(xmlfh,'');
155: utl_file.fclose(xmlfh);
156: EXCEPTION
157: WHEN OTHERS THEN
158: null;
159: END closeLabelFile;