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.GMD_LCF_ENGINE dependencies on DBMS_LOB

Line 58: dbms_lob.convertToBlob(dest_lob => l_blob,

54: FROM fnd_lobs
55: WHERE file_id = l_spec_id
56: FOR UPDATE NOWAIT;
57:
58: dbms_lob.convertToBlob(dest_lob => l_blob,
59: src_clob => l_clob,
60: amount => DBMS_LOB.LOBMAXSIZE,
61: dest_offset => l_des_offset,
62: src_offset => l_src_offset,

Line 60: amount => DBMS_LOB.LOBMAXSIZE,

56: FOR UPDATE NOWAIT;
57:
58: dbms_lob.convertToBlob(dest_lob => l_blob,
59: src_clob => l_clob,
60: amount => DBMS_LOB.LOBMAXSIZE,
61: dest_offset => l_des_offset,
62: src_offset => l_src_offset,
63: blob_csid => 0,
64: lang_context => l_lang_context,

Line 70: dbms_lob.FreeTemporary(l_clob);

66: IF l_debug = 'Y' THEN
67: gmd_debug.put_line('Warning:ConvertToBlob:'||l_warning);
68: END IF;
69: COMMIT;
70: dbms_lob.FreeTemporary(l_clob);
71: EXCEPTION
72: WHEN OTHERS THEN
73: IF l_debug = 'Y' THEN
74: gmd_debug.put_line(l_api_name||':'||sqlerrm);

Line 133: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.call);

129: l_line_str VARCHAR2(4000);
130: l_cat_string VARCHAR2(4000);
131: l_api_name VARCHAR2(40) := 'PRINT_DATA';
132: BEGIN
133: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.call);
134: dbms_lob.open(l_clob, DBMS_LOB.lob_readwrite);
135: FND_MESSAGE.SET_NAME('GMD', 'GMD_LCF_LOG_DATA');
136: l_string := FND_MESSAGE.GET||l_new_line_str;
137: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

Line 134: dbms_lob.open(l_clob, DBMS_LOB.lob_readwrite);

130: l_cat_string VARCHAR2(4000);
131: l_api_name VARCHAR2(40) := 'PRINT_DATA';
132: BEGIN
133: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.call);
134: dbms_lob.open(l_clob, DBMS_LOB.lob_readwrite);
135: FND_MESSAGE.SET_NAME('GMD', 'GMD_LCF_LOG_DATA');
136: l_string := FND_MESSAGE.GET||l_new_line_str;
137: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
138:

Line 137: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

133: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.call);
134: dbms_lob.open(l_clob, DBMS_LOB.lob_readwrite);
135: FND_MESSAGE.SET_NAME('GMD', 'GMD_LCF_LOG_DATA');
136: l_string := FND_MESSAGE.GET||l_new_line_str;
137: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
138:
139: l_string := RPAD(' Item',41,' ')||RPAD('Category', 30);
140: FOR l_rec IN Cur_get_tech_data LOOP
141: l_string := l_string||LPAD(l_rec.tech_parm_name, 10, ' ');

Line 146: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);

142: END LOOP;
143: l_string := l_string||l_new_line_str;
144:
145: l_line_str := RPAD('=', length(l_string), '=')||l_new_line_str;
146: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);
147: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
148: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);
149:
150: l_string := NULL;

Line 147: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

143: l_string := l_string||l_new_line_str;
144:
145: l_line_str := RPAD('=', length(l_string), '=')||l_new_line_str;
146: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);
147: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
148: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);
149:
150: l_string := NULL;
151: FOR l_rec IN Cur_get_data LOOP

Line 148: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);

144:
145: l_line_str := RPAD('=', length(l_string), '=')||l_new_line_str;
146: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);
147: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
148: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);
149:
150: l_string := NULL;
151: FOR l_rec IN Cur_get_data LOOP
152: IF NVL(l_item, ' ') <> l_rec.item THEN

Line 155: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

151: FOR l_rec IN Cur_get_data LOOP
152: IF NVL(l_item, ' ') <> l_rec.item THEN
153: IF l_string IS NOT NULL THEN
154: l_string := l_string || l_new_line_str;
155: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
156: l_string := NULL;
157: END IF;
158: END IF;
159: IF l_string IS NULL THEN

Line 175: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

171: l_string := l_string||LPAD(TO_CHAR(l_rec.value, '9990.99999'), 10, ' ');
172: l_item := l_rec.item;
173: END LOOP;
174: l_string := l_string || l_new_line_str;
175: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
176: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);
177: EXCEPTION
178: WHEN OTHERS THEN
179: IF l_debug = 'Y' THEN

Line 176: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);

172: l_item := l_rec.item;
173: END LOOP;
174: l_string := l_string || l_new_line_str;
175: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
176: dbms_lob.writeAppend(l_clob, length(l_line_str), l_line_str);
177: EXCEPTION
178: WHEN OTHERS THEN
179: IF l_debug = 'Y' THEN
180: gmd_debug.put_line(l_api_name||':'||sqlerrm);

Line 219: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

215:
216: l_api_name VARCHAR2(40) := 'PRINT_CONSTRAINTS';
217: BEGIN
218: l_string := ' '||l_new_line_str;
219: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
220:
221: l_string := '# Constraints: '||p_constraints||' # Variables: '||p_variables||l_new_line_str;
222: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
223:

Line 222: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

218: l_string := ' '||l_new_line_str;
219: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
220:
221: l_string := '# Constraints: '||p_constraints||' # Variables: '||p_variables||l_new_line_str;
222: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
223:
224: l_string := ' '||l_new_line_str;
225: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
226:

Line 225: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

221: l_string := '# Constraints: '||p_constraints||' # Variables: '||p_variables||l_new_line_str;
222: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
223:
224: l_string := ' '||l_new_line_str;
225: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
226:
227: l_string := 'Basic Constraint set:'||l_new_line_str;
228: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
229:

Line 228: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

224: l_string := ' '||l_new_line_str;
225: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
226:
227: l_string := 'Basic Constraint set:'||l_new_line_str;
228: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
229:
230: l_string := RPAD(p_cons(1), 25, ' ')||' = '||RPAD(ROUND(p_matrix(1)(0), 5),20);
231: IF (ABS(p_solved_matrix(1)(0)) > l_LGP_EPS_ZERO) AND p_reenter(p_basic(1)) = 0 THEN
232: l_string := l_string||'**** Infeasible ****';

Line 235: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

231: IF (ABS(p_solved_matrix(1)(0)) > l_LGP_EPS_ZERO) AND p_reenter(p_basic(1)) = 0 THEN
232: l_string := l_string||'**** Infeasible ****';
233: END IF;
234: l_string := l_string||l_new_line_str;
235: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
236:
237: FOR i IN 2..p_constraints LOOP
238: IF p_reenter(p_basic(i)) = 0 THEN
239: l_string := RPAD(p_cons(i), 25, ' ')||' <= '||RPAD(ROUND(p_matrix(i)(0), 5), 20);

Line 247: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

243: IF (ABS(p_solved_matrix(i)(0)) > l_LGP_EPS_ZERO) AND p_reenter(p_solved_basic(i)) = 0 THEN
244: l_string := l_string||'**** Infeasible ****';
245: END IF;
246: l_string := l_string||l_new_line_str;
247: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
248: END LOOP;
249:
250: l_string := ' '||l_new_line_str;
251: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

Line 251: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

247: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
248: END LOOP;
249:
250: l_string := ' '||l_new_line_str;
251: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
252: EXCEPTION
253: WHEN OTHERS THEN
254: IF l_debug = 'Y' THEN
255: gmd_debug.put_line(l_api_name||':'||sqlerrm);

Line 294: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

290: l_cat_string VARCHAR2(4000);
291: l_api_name VARCHAR2(40) := 'PRINT_DEBUG';
292: BEGIN
293: l_string := ' '||l_new_line_str;
294: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
295: l_string := '*** Debugging Information (Printed only if log level set to statement) ***';
296: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
297: l_string := 'Functional: '||-1*p_matrix(0)(0)||' Error code: '||p_return_code||l_new_line_str;
298: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

Line 296: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

292: BEGIN
293: l_string := ' '||l_new_line_str;
294: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
295: l_string := '*** Debugging Information (Printed only if log level set to statement) ***';
296: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
297: l_string := 'Functional: '||-1*p_matrix(0)(0)||' Error code: '||p_return_code||l_new_line_str;
298: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
299:
300: l_string := ' '||l_new_line_str;

Line 298: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

294: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
295: l_string := '*** Debugging Information (Printed only if log level set to statement) ***';
296: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
297: l_string := 'Functional: '||-1*p_matrix(0)(0)||' Error code: '||p_return_code||l_new_line_str;
298: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
299:
300: l_string := ' '||l_new_line_str;
301: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
302:

Line 301: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

297: l_string := 'Functional: '||-1*p_matrix(0)(0)||' Error code: '||p_return_code||l_new_line_str;
298: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
299:
300: l_string := ' '||l_new_line_str;
301: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
302:
303: l_string := 'Basic set:'||l_new_line_str;
304: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
305:

Line 304: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

300: l_string := ' '||l_new_line_str;
301: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
302:
303: l_string := 'Basic set:'||l_new_line_str;
304: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
305:
306: FOR i IN 1..p_constraints LOOP
307: l_string := RPAD(p_cons(i), 25, ' ')||' '||p_basic(i)||'. '||RPAD(p_var(p_basic(i)), 25, ' ')||' '||ROUND(p_matrix(i)(0), 5)||l_new_line_str;
308: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

Line 308: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

304: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
305:
306: FOR i IN 1..p_constraints LOOP
307: l_string := RPAD(p_cons(i), 25, ' ')||' '||p_basic(i)||'. '||RPAD(p_var(p_basic(i)), 25, ' ')||' '||ROUND(p_matrix(i)(0), 5)||l_new_line_str;
308: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
309: END LOOP;
310:
311: l_string := ' '||l_new_line_str;
312: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

Line 312: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

308: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
309: END LOOP;
310:
311: l_string := ' '||l_new_line_str;
312: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
313:
314: l_string := 'Shadow costs:'||l_new_line_str;
315: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
316:

Line 315: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

311: l_string := ' '||l_new_line_str;
312: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
313:
314: l_string := 'Shadow costs:'||l_new_line_str;
315: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
316:
317:
318: FOR j IN 1..p_variables LOOP
319: IF p_reenter(j) = 1 THEN

Line 328: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

324: l_value := ROUND(p_matrix(0)(j),5);
325: l_print_value := RPAD(TO_CHAR(l_value, '9990.99999'), 10);
326:
327: l_string := j||'. '||RPAD(p_var(j),30, ' ')||' '||l_print_value||' '||l_bool_char||l_new_line_str;
328: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
329: END LOOP;
330:
331: l_string := ' '||l_new_line_str;
332: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

Line 332: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

328: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
329: END LOOP;
330:
331: l_string := ' '||l_new_line_str;
332: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
333:
334: l_string := 'Matrix:'||l_new_line_str;
335: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
336:

Line 335: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

331: l_string := ' '||l_new_line_str;
332: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
333:
334: l_string := 'Matrix:'||l_new_line_str;
335: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
336:
337:
338: FOR i IN 0..p_constraints+1 LOOP
339: l_value := ROUND(p_matrix(i)(0),5);

Line 343: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

339: l_value := ROUND(p_matrix(i)(0),5);
340: l_print_value := RPAD(TO_CHAR(l_value, '9990.99999'), 10);
341:
342: l_string := RPAD(i,4, ' ')||' '||l_print_value||' '||l_new_line_str;
343: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
344:
345: l_print_line := NULL;
346: FOR j IN 1..p_variables LOOP
347: l_value := ROUND(p_matrix(i)(j),5);

Line 352: dbms_lob.writeAppend(l_clob, length(l_print_line), l_print_line);

348: l_print_value := RPAD(TO_CHAR(l_value, '9990.99999'), 10);
349: l_print_line := l_print_line||l_print_value||' ';
350: END LOOP;
351: l_print_line := l_print_line||l_new_line_str;
352: dbms_lob.writeAppend(l_clob, length(l_print_line), l_print_line);
353: END LOOP;
354:
355: l_string := ' '||l_new_line_str;
356: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

Line 356: dbms_lob.writeAppend(l_clob, length(l_string), l_string);

352: dbms_lob.writeAppend(l_clob, length(l_print_line), l_print_line);
353: END LOOP;
354:
355: l_string := ' '||l_new_line_str;
356: dbms_lob.writeAppend(l_clob, length(l_string), l_string);
357:
358: EXCEPTION
359: WHEN OTHERS THEN
360: IF l_debug = 'Y' THEN