DBA Data[Home] [Help]

APPS.WMS_LABEL_PUB dependencies on WMS_CLABEL

Line 91: WMS_CLABEL.setDefaultLabelInfo(g_label,g_printer,g_no_copies);

87: as per the data */
88: --g_printer := Get_printer_name();
89: g_label := 'Loation_Label';
90: g_printer := '3op1035ap';
91: WMS_CLABEL.setDefaultLabelInfo(g_label,g_printer,g_no_copies);
92: WMS_CLABEL.openLabelFile(g_dir,g_file);
93: FOR l_loc_rec IN loc_cursor
94: LOOP
95: IF l_printer_header_once = 'Y' then

Line 92: WMS_CLABEL.openLabelFile(g_dir,g_file);

88: --g_printer := Get_printer_name();
89: g_label := 'Loation_Label';
90: g_printer := '3op1035ap';
91: WMS_CLABEL.setDefaultLabelInfo(g_label,g_printer,g_no_copies);
92: WMS_CLABEL.openLabelFile(g_dir,g_file);
93: FOR l_loc_rec IN loc_cursor
94: LOOP
95: IF l_printer_header_once = 'Y' then
96: WMS_CLABEL.clearHeader;

Line 96: WMS_CLABEL.clearHeader;

92: WMS_CLABEL.openLabelFile(g_dir,g_file);
93: FOR l_loc_rec IN loc_cursor
94: LOOP
95: IF l_printer_header_once = 'Y' then
96: WMS_CLABEL.clearHeader;
97: g_variable_name := 'Zone';
98: g_variable_value := l_loc_rec.subinventory_code;
99: WMS_CLABEL.setHeaderVariable(g_variable_name,g_variable_value);
100: g_variable_name := 'Locator';

Line 99: WMS_CLABEL.setHeaderVariable(g_variable_name,g_variable_value);

95: IF l_printer_header_once = 'Y' then
96: WMS_CLABEL.clearHeader;
97: g_variable_name := 'Zone';
98: g_variable_value := l_loc_rec.subinventory_code;
99: WMS_CLABEL.setHeaderVariable(g_variable_name,g_variable_value);
100: g_variable_name := 'Locator';
101: g_variable_value := l_loc_rec.locator;
102: WMS_CLABEL.setHeaderVariable(g_variable_name,g_variable_value);
103: -- Note: Header is also useful to

Line 102: WMS_CLABEL.setHeaderVariable(g_variable_name,g_variable_value);

98: g_variable_value := l_loc_rec.subinventory_code;
99: WMS_CLABEL.setHeaderVariable(g_variable_name,g_variable_value);
100: g_variable_name := 'Locator';
101: g_variable_value := l_loc_rec.locator;
102: WMS_CLABEL.setHeaderVariable(g_variable_name,g_variable_value);
103: -- Note: Header is also useful to
104: -- define the static strings like "Address" on the
105: -- label themselves as variables so that language
106: -- translations can be done

Line 114: WMS_CLABEL.clearLine; -- Clear all the previous line variables

110: -- FOR l_loc_rec in loc_cursor
111: -- LOOP
112: l_rec_count := l_rec_count+1;
113: -- dbms_output.put_line('first row '||l_loc_rec.locator||l_loc_rec.subinventory_code);
114: WMS_CLABEL.clearLine; -- Clear all the previous line variables
115: g_printer := '3op1035ap';
116: g_label := 'Location_Label';
117: -- WMS_CLABEL.setLabelInfo(g_label,g_printer,g_no_copies); -- do this to override
118: WMS_CLABEL.setLabelInfo(null,null,null); -- do this to override

Line 117: -- WMS_CLABEL.setLabelInfo(g_label,g_printer,g_no_copies); -- do this to override

113: -- dbms_output.put_line('first row '||l_loc_rec.locator||l_loc_rec.subinventory_code);
114: WMS_CLABEL.clearLine; -- Clear all the previous line variables
115: g_printer := '3op1035ap';
116: g_label := 'Location_Label';
117: -- WMS_CLABEL.setLabelInfo(g_label,g_printer,g_no_copies); -- do this to override
118: WMS_CLABEL.setLabelInfo(null,null,null); -- do this to override
119: -- Now set all the label variables
120: g_variable_name := 'Zone';
121: g_variable_value := l_loc_rec.subinventory_code;

Line 118: WMS_CLABEL.setLabelInfo(null,null,null); -- do this to override

114: WMS_CLABEL.clearLine; -- Clear all the previous line variables
115: g_printer := '3op1035ap';
116: g_label := 'Location_Label';
117: -- WMS_CLABEL.setLabelInfo(g_label,g_printer,g_no_copies); -- do this to override
118: WMS_CLABEL.setLabelInfo(null,null,null); -- do this to override
119: -- Now set all the label variables
120: g_variable_name := 'Zone';
121: g_variable_value := l_loc_rec.subinventory_code;
122: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);

Line 122: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);

118: WMS_CLABEL.setLabelInfo(null,null,null); -- do this to override
119: -- Now set all the label variables
120: g_variable_name := 'Zone';
121: g_variable_value := l_loc_rec.subinventory_code;
122: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);
123: g_variable_name := 'Locator';
124: g_variable_value := l_loc_rec.locator;
125: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);
126: WMS_CLABEL.writeLabel(2); -- This call writes the variables of both the header and the lines.

Line 125: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);

121: g_variable_value := l_loc_rec.subinventory_code;
122: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);
123: g_variable_name := 'Locator';
124: g_variable_value := l_loc_rec.locator;
125: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);
126: WMS_CLABEL.writeLabel(2); -- This call writes the variables of both the header and the lines.
127: END LOOP;
128: WMS_CLABEL.closeLabelFile;
129: --dbms_output.put_line('Total records in the label '||to_char(l_rec_count));

Line 126: WMS_CLABEL.writeLabel(2); -- This call writes the variables of both the header and the lines.

122: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);
123: g_variable_name := 'Locator';
124: g_variable_value := l_loc_rec.locator;
125: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);
126: WMS_CLABEL.writeLabel(2); -- This call writes the variables of both the header and the lines.
127: END LOOP;
128: WMS_CLABEL.closeLabelFile;
129: --dbms_output.put_line('Total records in the label '||to_char(l_rec_count));
130: x_return_status := fnd_api.g_ret_sts_success;

Line 128: WMS_CLABEL.closeLabelFile;

124: g_variable_value := l_loc_rec.locator;
125: WMS_CLABEL.setLineVariable(g_variable_name,g_variable_value);
126: WMS_CLABEL.writeLabel(2); -- This call writes the variables of both the header and the lines.
127: END LOOP;
128: WMS_CLABEL.closeLabelFile;
129: --dbms_output.put_line('Total records in the label '||to_char(l_rec_count));
130: x_return_status := fnd_api.g_ret_sts_success;
131: exception
132: when others then