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.INV_RCV_INTEGRATION_PVT dependencies on DBMS_SQL

Line 109: l_epc_cursor := dbms_sql.open_cursor;

105: IF (l_debug = 1) THEN
106: print_debug('l_epc_sql: '||l_epc_sql,4);
107: END IF;
108:
109: l_epc_cursor := dbms_sql.open_cursor;
110: BEGIN
111: dbms_sql.parse(l_epc_cursor,l_epc_sql,dbms_sql.v7);
112: EXCEPTION
113: WHEN OTHERS THEN

Line 111: dbms_sql.parse(l_epc_cursor,l_epc_sql,dbms_sql.v7);

107: END IF;
108:
109: l_epc_cursor := dbms_sql.open_cursor;
110: BEGIN
111: dbms_sql.parse(l_epc_cursor,l_epc_sql,dbms_sql.v7);
112: EXCEPTION
113: WHEN OTHERS THEN
114: l_last_error_pos := dbms_sql.last_error_position();
115: l_temp_str := Substr(l_epc_sql, l_last_error_pos-5, 50);

Line 114: l_last_error_pos := dbms_sql.last_error_position();

110: BEGIN
111: dbms_sql.parse(l_epc_cursor,l_epc_sql,dbms_sql.v7);
112: EXCEPTION
113: WHEN OTHERS THEN
114: l_last_error_pos := dbms_sql.last_error_position();
115: l_temp_str := Substr(l_epc_sql, l_last_error_pos-5, 50);
116: IF l_debug = 1 THEN
117: print_debug('Error in parse sql statement, at '||l_temp_str,4);
118: END IF;

Line 122: dbms_sql.bind_variable(l_epc_cursor,':lpn', p_lpn);

118: END IF;
119: RAISE fnd_api.g_exc_unexpected_error;
120: END;
121:
122: dbms_sql.bind_variable(l_epc_cursor,':lpn', p_lpn);
123: dbms_sql.bind_variable(l_epc_cursor,':src_grp_id', p_src_grp_id);
124: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
125: l_return := dbms_sql.execute(l_epc_cursor);
126:

Line 123: dbms_sql.bind_variable(l_epc_cursor,':src_grp_id', p_src_grp_id);

119: RAISE fnd_api.g_exc_unexpected_error;
120: END;
121:
122: dbms_sql.bind_variable(l_epc_cursor,':lpn', p_lpn);
123: dbms_sql.bind_variable(l_epc_cursor,':src_grp_id', p_src_grp_id);
124: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
125: l_return := dbms_sql.execute(l_epc_cursor);
126:
127: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN

Line 124: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);

120: END;
121:
122: dbms_sql.bind_variable(l_epc_cursor,':lpn', p_lpn);
123: dbms_sql.bind_variable(l_epc_cursor,':src_grp_id', p_src_grp_id);
124: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
125: l_return := dbms_sql.execute(l_epc_cursor);
126:
127: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN
128: dbms_sql.column_value(l_epc_cursor, 1, l_epc_value);

Line 125: l_return := dbms_sql.execute(l_epc_cursor);

121:
122: dbms_sql.bind_variable(l_epc_cursor,':lpn', p_lpn);
123: dbms_sql.bind_variable(l_epc_cursor,':src_grp_id', p_src_grp_id);
124: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
125: l_return := dbms_sql.execute(l_epc_cursor);
126:
127: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN
128: dbms_sql.column_value(l_epc_cursor, 1, l_epc_value);
129: IF (l_debug = 1) THEN

Line 127: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN

123: dbms_sql.bind_variable(l_epc_cursor,':src_grp_id', p_src_grp_id);
124: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
125: l_return := dbms_sql.execute(l_epc_cursor);
126:
127: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN
128: dbms_sql.column_value(l_epc_cursor, 1, l_epc_value);
129: IF (l_debug = 1) THEN
130: print_debug('l_epc_value: '||l_epc_value,4);
131: END IF;

Line 128: dbms_sql.column_value(l_epc_cursor, 1, l_epc_value);

124: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
125: l_return := dbms_sql.execute(l_epc_cursor);
126:
127: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN
128: dbms_sql.column_value(l_epc_cursor, 1, l_epc_value);
129: IF (l_debug = 1) THEN
130: print_debug('l_epc_value: '||l_epc_value,4);
131: END IF;
132: x_epc_value := l_epc_value;

Line 137: dbms_sql.close_cursor(l_epc_cursor);

133: ELSE
134: x_epc_value := NULL;
135: END IF;
136:
137: dbms_sql.close_cursor(l_epc_cursor);
138: ELSE --Serial
139: l_epc_sql := 'SELECT ' || l_epc_column;
140: l_epc_sql := l_epc_sql || ' FROM mtl_serial_numbers_temp';
141: l_epc_sql := l_epc_sql || ' WHERE rowid = :row_id';

Line 147: l_epc_cursor := dbms_sql.open_cursor;

143: IF (l_debug = 1) THEN
144: print_debug('l_epc_sql: '||l_epc_sql,4);
145: END IF;
146:
147: l_epc_cursor := dbms_sql.open_cursor;
148: BEGIN
149: dbms_sql.parse(l_epc_cursor,l_epc_sql,dbms_sql.v7);
150: EXCEPTION
151: WHEN OTHERS THEN

Line 149: dbms_sql.parse(l_epc_cursor,l_epc_sql,dbms_sql.v7);

145: END IF;
146:
147: l_epc_cursor := dbms_sql.open_cursor;
148: BEGIN
149: dbms_sql.parse(l_epc_cursor,l_epc_sql,dbms_sql.v7);
150: EXCEPTION
151: WHEN OTHERS THEN
152: l_last_error_pos := dbms_sql.last_error_position();
153: l_temp_str := Substr(l_epc_sql, l_last_error_pos-10, 50);

Line 152: l_last_error_pos := dbms_sql.last_error_position();

148: BEGIN
149: dbms_sql.parse(l_epc_cursor,l_epc_sql,dbms_sql.v7);
150: EXCEPTION
151: WHEN OTHERS THEN
152: l_last_error_pos := dbms_sql.last_error_position();
153: l_temp_str := Substr(l_epc_sql, l_last_error_pos-10, 50);
154: IF l_debug = 1 THEN
155: print_debug('Error in parse sql statement, at '||l_temp_str,4);
156: print_debug('ERROR CODE = '||SQLCODE||' ERROR MESSAGE = '||Sqlerrm,4);

Line 161: dbms_sql.bind_variable(l_epc_cursor,':row_id', p_ser_if_rowid);

157: END IF;
158: RAISE fnd_api.g_exc_unexpected_error;
159: END;
160:
161: dbms_sql.bind_variable(l_epc_cursor,':row_id', p_ser_if_rowid);
162: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
163:
164: l_return := dbms_sql.execute(l_epc_cursor);
165:

Line 162: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);

158: RAISE fnd_api.g_exc_unexpected_error;
159: END;
160:
161: dbms_sql.bind_variable(l_epc_cursor,':row_id', p_ser_if_rowid);
162: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
163:
164: l_return := dbms_sql.execute(l_epc_cursor);
165:
166: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN

Line 164: l_return := dbms_sql.execute(l_epc_cursor);

160:
161: dbms_sql.bind_variable(l_epc_cursor,':row_id', p_ser_if_rowid);
162: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
163:
164: l_return := dbms_sql.execute(l_epc_cursor);
165:
166: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN
167: dbms_sql.column_value(l_epc_cursor, 1, l_epc_value);
168: IF (l_debug = 1) THEN

Line 166: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN

162: dbms_sql.define_column(l_epc_cursor, 1, l_epc_value, 30);
163:
164: l_return := dbms_sql.execute(l_epc_cursor);
165:
166: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN
167: dbms_sql.column_value(l_epc_cursor, 1, l_epc_value);
168: IF (l_debug = 1) THEN
169: print_debug('l_epc_value: '||l_epc_value,4);
170: END IF;

Line 167: dbms_sql.column_value(l_epc_cursor, 1, l_epc_value);

163:
164: l_return := dbms_sql.execute(l_epc_cursor);
165:
166: IF dbms_sql.fetch_rows(l_epc_cursor) <> 0 THEN
167: dbms_sql.column_value(l_epc_cursor, 1, l_epc_value);
168: IF (l_debug = 1) THEN
169: print_debug('l_epc_value: '||l_epc_value,4);
170: END IF;
171: x_epc_value := l_epc_value;

Line 175: dbms_sql.close_cursor(l_epc_cursor);

171: x_epc_value := l_epc_value;
172: ELSE
173: x_epc_value := NULL;
174: END IF;
175: dbms_sql.close_cursor(l_epc_cursor);
176: END IF;
177: END IF;
178:
179: EXCEPTION

Line 185: dbms_sql.close_cursor(l_epc_cursor);

181: IF l_debug = 1 THEN
182: print_debug('Error in get_epc_info at progress:'||l_progress,4);
183: print_debug('ERROR CODE = '||SQLCODE||' ERROR MESSAGE = '||Sqlerrm,4);
184: END IF;
185: dbms_sql.close_cursor(l_epc_cursor);
186: END get_epc_info;
187:
188:
189: /*****bug4187663, comment out the call to serial uniqueness api