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.FND_TRANSACTION_PIPE dependencies on DBMS_PIPE

Line 123: status := dbms_pipe.receive_message(token_pipe, timeout);

119: fnd_transaction.debug_info('fnd_trn_pipe.get_manager',
120: 'Trying token pipe',
121: token_pipe);
122: end if;
123: status := dbms_pipe.receive_message(token_pipe, timeout);
124:
125: -- Exit loop if we got the token
126: exit when (status = 0);
127:

Line 236: return_pipe varchar2(30) := dbms_pipe.unique_session_name;

232: arg_18 in varchar2,
233: arg_19 in varchar2,
234: arg_20 in varchar2) return number is
235:
236: return_pipe varchar2(30) := dbms_pipe.unique_session_name;
237: argtotal number;
238: argslen_err exception;
239: tmpstr varchar2(480);
240: submit_time date;

Line 251: dbms_pipe.reset_buffer;

247: counter2 number;
248:
249: begin
250:
251: dbms_pipe.reset_buffer;
252:
253: -- Pack message header
254: dbms_pipe.pack_message (send_type);
255: dbms_pipe.pack_message (expiration_time);

Line 254: dbms_pipe.pack_message (send_type);

250:
251: dbms_pipe.reset_buffer;
252:
253: -- Pack message header
254: dbms_pipe.pack_message (send_type);
255: dbms_pipe.pack_message (expiration_time);
256: dbms_pipe.pack_message (request_id);
257: dbms_pipe.pack_message (return_pipe);
258: dbms_pipe.pack_message (nls_lang);

Line 255: dbms_pipe.pack_message (expiration_time);

251: dbms_pipe.reset_buffer;
252:
253: -- Pack message header
254: dbms_pipe.pack_message (send_type);
255: dbms_pipe.pack_message (expiration_time);
256: dbms_pipe.pack_message (request_id);
257: dbms_pipe.pack_message (return_pipe);
258: dbms_pipe.pack_message (nls_lang);
259: dbms_pipe.pack_message (nls_num_chars);

Line 256: dbms_pipe.pack_message (request_id);

252:
253: -- Pack message header
254: dbms_pipe.pack_message (send_type);
255: dbms_pipe.pack_message (expiration_time);
256: dbms_pipe.pack_message (request_id);
257: dbms_pipe.pack_message (return_pipe);
258: dbms_pipe.pack_message (nls_lang);
259: dbms_pipe.pack_message (nls_num_chars);
260: dbms_pipe.pack_message (nls_date_lang);

Line 257: dbms_pipe.pack_message (return_pipe);

253: -- Pack message header
254: dbms_pipe.pack_message (send_type);
255: dbms_pipe.pack_message (expiration_time);
256: dbms_pipe.pack_message (request_id);
257: dbms_pipe.pack_message (return_pipe);
258: dbms_pipe.pack_message (nls_lang);
259: dbms_pipe.pack_message (nls_num_chars);
260: dbms_pipe.pack_message (nls_date_lang);
261: dbms_pipe.pack_message (secgrpid);

Line 258: dbms_pipe.pack_message (nls_lang);

254: dbms_pipe.pack_message (send_type);
255: dbms_pipe.pack_message (expiration_time);
256: dbms_pipe.pack_message (request_id);
257: dbms_pipe.pack_message (return_pipe);
258: dbms_pipe.pack_message (nls_lang);
259: dbms_pipe.pack_message (nls_num_chars);
260: dbms_pipe.pack_message (nls_date_lang);
261: dbms_pipe.pack_message (secgrpid);
262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);

Line 259: dbms_pipe.pack_message (nls_num_chars);

255: dbms_pipe.pack_message (expiration_time);
256: dbms_pipe.pack_message (request_id);
257: dbms_pipe.pack_message (return_pipe);
258: dbms_pipe.pack_message (nls_lang);
259: dbms_pipe.pack_message (nls_num_chars);
260: dbms_pipe.pack_message (nls_date_lang);
261: dbms_pipe.pack_message (secgrpid);
262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);
263: dbms_pipe.pack_message (enable_trace_flag);

Line 260: dbms_pipe.pack_message (nls_date_lang);

256: dbms_pipe.pack_message (request_id);
257: dbms_pipe.pack_message (return_pipe);
258: dbms_pipe.pack_message (nls_lang);
259: dbms_pipe.pack_message (nls_num_chars);
260: dbms_pipe.pack_message (nls_date_lang);
261: dbms_pipe.pack_message (secgrpid);
262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);
263: dbms_pipe.pack_message (enable_trace_flag);
264: dbms_pipe.pack_message (fnd_global.user_id);

Line 261: dbms_pipe.pack_message (secgrpid);

257: dbms_pipe.pack_message (return_pipe);
258: dbms_pipe.pack_message (nls_lang);
259: dbms_pipe.pack_message (nls_num_chars);
260: dbms_pipe.pack_message (nls_date_lang);
261: dbms_pipe.pack_message (secgrpid);
262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);
263: dbms_pipe.pack_message (enable_trace_flag);
264: dbms_pipe.pack_message (fnd_global.user_id);
265: dbms_pipe.pack_message (fnd_global.resp_appl_id);

Line 262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);

258: dbms_pipe.pack_message (nls_lang);
259: dbms_pipe.pack_message (nls_num_chars);
260: dbms_pipe.pack_message (nls_date_lang);
261: dbms_pipe.pack_message (secgrpid);
262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);
263: dbms_pipe.pack_message (enable_trace_flag);
264: dbms_pipe.pack_message (fnd_global.user_id);
265: dbms_pipe.pack_message (fnd_global.resp_appl_id);
266: dbms_pipe.pack_message (fnd_global.resp_id);

Line 263: dbms_pipe.pack_message (enable_trace_flag);

259: dbms_pipe.pack_message (nls_num_chars);
260: dbms_pipe.pack_message (nls_date_lang);
261: dbms_pipe.pack_message (secgrpid);
262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);
263: dbms_pipe.pack_message (enable_trace_flag);
264: dbms_pipe.pack_message (fnd_global.user_id);
265: dbms_pipe.pack_message (fnd_global.resp_appl_id);
266: dbms_pipe.pack_message (fnd_global.resp_id);
267: dbms_pipe.pack_message (fnd_global.login_id);

Line 264: dbms_pipe.pack_message (fnd_global.user_id);

260: dbms_pipe.pack_message (nls_date_lang);
261: dbms_pipe.pack_message (secgrpid);
262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);
263: dbms_pipe.pack_message (enable_trace_flag);
264: dbms_pipe.pack_message (fnd_global.user_id);
265: dbms_pipe.pack_message (fnd_global.resp_appl_id);
266: dbms_pipe.pack_message (fnd_global.resp_id);
267: dbms_pipe.pack_message (fnd_global.login_id);
268: dbms_pipe.pack_message (application);

Line 265: dbms_pipe.pack_message (fnd_global.resp_appl_id);

261: dbms_pipe.pack_message (secgrpid);
262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);
263: dbms_pipe.pack_message (enable_trace_flag);
264: dbms_pipe.pack_message (fnd_global.user_id);
265: dbms_pipe.pack_message (fnd_global.resp_appl_id);
266: dbms_pipe.pack_message (fnd_global.resp_id);
267: dbms_pipe.pack_message (fnd_global.login_id);
268: dbms_pipe.pack_message (application);
269: dbms_pipe.pack_message (program);

Line 266: dbms_pipe.pack_message (fnd_global.resp_id);

262: dbms_pipe.pack_message (FND_CONC_GLOBAL.OPS_INST_NUM);
263: dbms_pipe.pack_message (enable_trace_flag);
264: dbms_pipe.pack_message (fnd_global.user_id);
265: dbms_pipe.pack_message (fnd_global.resp_appl_id);
266: dbms_pipe.pack_message (fnd_global.resp_id);
267: dbms_pipe.pack_message (fnd_global.login_id);
268: dbms_pipe.pack_message (application);
269: dbms_pipe.pack_message (program);
270: dbms_pipe.pack_message (org_type);

Line 267: dbms_pipe.pack_message (fnd_global.login_id);

263: dbms_pipe.pack_message (enable_trace_flag);
264: dbms_pipe.pack_message (fnd_global.user_id);
265: dbms_pipe.pack_message (fnd_global.resp_appl_id);
266: dbms_pipe.pack_message (fnd_global.resp_id);
267: dbms_pipe.pack_message (fnd_global.login_id);
268: dbms_pipe.pack_message (application);
269: dbms_pipe.pack_message (program);
270: dbms_pipe.pack_message (org_type);
271: dbms_pipe.pack_message (org_id);

Line 268: dbms_pipe.pack_message (application);

264: dbms_pipe.pack_message (fnd_global.user_id);
265: dbms_pipe.pack_message (fnd_global.resp_appl_id);
266: dbms_pipe.pack_message (fnd_global.resp_id);
267: dbms_pipe.pack_message (fnd_global.login_id);
268: dbms_pipe.pack_message (application);
269: dbms_pipe.pack_message (program);
270: dbms_pipe.pack_message (org_type);
271: dbms_pipe.pack_message (org_id);
272:

Line 269: dbms_pipe.pack_message (program);

265: dbms_pipe.pack_message (fnd_global.resp_appl_id);
266: dbms_pipe.pack_message (fnd_global.resp_id);
267: dbms_pipe.pack_message (fnd_global.login_id);
268: dbms_pipe.pack_message (application);
269: dbms_pipe.pack_message (program);
270: dbms_pipe.pack_message (org_type);
271: dbms_pipe.pack_message (org_id);
272:
273: -- Pack arguments

Line 270: dbms_pipe.pack_message (org_type);

266: dbms_pipe.pack_message (fnd_global.resp_id);
267: dbms_pipe.pack_message (fnd_global.login_id);
268: dbms_pipe.pack_message (application);
269: dbms_pipe.pack_message (program);
270: dbms_pipe.pack_message (org_type);
271: dbms_pipe.pack_message (org_id);
272:
273: -- Pack arguments
274: argtotal := 0;

Line 271: dbms_pipe.pack_message (org_id);

267: dbms_pipe.pack_message (fnd_global.login_id);
268: dbms_pipe.pack_message (application);
269: dbms_pipe.pack_message (program);
270: dbms_pipe.pack_message (org_type);
271: dbms_pipe.pack_message (org_id);
272:
273: -- Pack arguments
274: argtotal := 0;
275:

Line 282: dbms_pipe.pack_message (tmpstr);

278: argtotal := argtotal + length(tmpstr);
279: if argtotal > fnd_transaction.ARGSTOTAL then
280: raise argslen_err;
281: end if;
282: dbms_pipe.pack_message (tmpstr);
283: if (arg_2 = CHR(0)) then goto end_pack; end if;
284: tmpstr := substr(arg_2, 1, fnd_transaction.ARGMAX);
285: argtotal := argtotal + length(tmpstr);
286: if argtotal > fnd_transaction.ARGSTOTAL then

Line 289: dbms_pipe.pack_message (tmpstr);

285: argtotal := argtotal + length(tmpstr);
286: if argtotal > fnd_transaction.ARGSTOTAL then
287: raise argslen_err;
288: end if;
289: dbms_pipe.pack_message (tmpstr);
290: if (arg_3 = CHR(0)) then goto end_pack; end if;
291: tmpstr := substr(arg_3, 1, fnd_transaction.ARGMAX);
292: argtotal := argtotal + length(tmpstr);
293: if argtotal > fnd_transaction.ARGSTOTAL then

Line 296: dbms_pipe.pack_message (tmpstr);

292: argtotal := argtotal + length(tmpstr);
293: if argtotal > fnd_transaction.ARGSTOTAL then
294: raise argslen_err;
295: end if;
296: dbms_pipe.pack_message (tmpstr);
297: if (arg_4 = CHR(0)) then goto end_pack; end if;
298: tmpstr := substr(arg_4, 1, fnd_transaction.ARGMAX);
299: argtotal := argtotal + length(tmpstr);
300: if argtotal > fnd_transaction.ARGSTOTAL then

Line 303: dbms_pipe.pack_message (tmpstr);

299: argtotal := argtotal + length(tmpstr);
300: if argtotal > fnd_transaction.ARGSTOTAL then
301: raise argslen_err;
302: end if;
303: dbms_pipe.pack_message (tmpstr);
304: if (arg_5 = CHR(0)) then goto end_pack; end if;
305: tmpstr := substr(arg_5, 1, fnd_transaction.ARGMAX);
306: argtotal := argtotal + length(tmpstr);
307: if argtotal > fnd_transaction.ARGSTOTAL then

Line 310: dbms_pipe.pack_message (tmpstr);

306: argtotal := argtotal + length(tmpstr);
307: if argtotal > fnd_transaction.ARGSTOTAL then
308: raise argslen_err;
309: end if;
310: dbms_pipe.pack_message (tmpstr);
311: if (arg_6 = CHR(0)) then goto end_pack; end if;
312: tmpstr := substr(arg_6, 1, fnd_transaction.ARGMAX);
313: argtotal := argtotal + length(tmpstr);
314: if argtotal > fnd_transaction.ARGSTOTAL then

Line 317: dbms_pipe.pack_message (tmpstr);

313: argtotal := argtotal + length(tmpstr);
314: if argtotal > fnd_transaction.ARGSTOTAL then
315: raise argslen_err;
316: end if;
317: dbms_pipe.pack_message (tmpstr);
318: if (arg_7 = CHR(0)) then goto end_pack; end if;
319: tmpstr := substr(arg_7, 1, fnd_transaction.ARGMAX);
320: argtotal := argtotal + length(tmpstr);
321: if argtotal > fnd_transaction.ARGSTOTAL then

Line 324: dbms_pipe.pack_message (tmpstr);

320: argtotal := argtotal + length(tmpstr);
321: if argtotal > fnd_transaction.ARGSTOTAL then
322: raise argslen_err;
323: end if;
324: dbms_pipe.pack_message (tmpstr);
325: if (arg_8 = CHR(0)) then goto end_pack; end if;
326: tmpstr := substr(arg_8, 1, fnd_transaction.ARGMAX);
327: argtotal := argtotal + length(tmpstr);
328: if argtotal > fnd_transaction.ARGSTOTAL then

Line 331: dbms_pipe.pack_message (tmpstr);

327: argtotal := argtotal + length(tmpstr);
328: if argtotal > fnd_transaction.ARGSTOTAL then
329: raise argslen_err;
330: end if;
331: dbms_pipe.pack_message (tmpstr);
332: if (arg_9 = CHR(0)) then goto end_pack; end if;
333: tmpstr := substr(arg_9, 1, fnd_transaction.ARGMAX);
334: argtotal := argtotal + length(tmpstr);
335: if argtotal > fnd_transaction.ARGSTOTAL then

Line 338: dbms_pipe.pack_message (tmpstr);

334: argtotal := argtotal + length(tmpstr);
335: if argtotal > fnd_transaction.ARGSTOTAL then
336: raise argslen_err;
337: end if;
338: dbms_pipe.pack_message (tmpstr);
339: if (arg_10 = CHR(0)) then goto end_pack; end if;
340: tmpstr := substr(arg_10, 1, fnd_transaction.ARGMAX);
341: argtotal := argtotal + length(tmpstr);
342: if argtotal > fnd_transaction.ARGSTOTAL then

Line 345: dbms_pipe.pack_message (tmpstr);

341: argtotal := argtotal + length(tmpstr);
342: if argtotal > fnd_transaction.ARGSTOTAL then
343: raise argslen_err;
344: end if;
345: dbms_pipe.pack_message (tmpstr);
346: if (arg_11 = CHR(0)) then goto end_pack; end if;
347: tmpstr := substr(arg_11, 1, fnd_transaction.ARGMAX);
348: argtotal := argtotal + length(tmpstr);
349: if argtotal > fnd_transaction.ARGSTOTAL then

Line 352: dbms_pipe.pack_message (tmpstr);

348: argtotal := argtotal + length(tmpstr);
349: if argtotal > fnd_transaction.ARGSTOTAL then
350: raise argslen_err;
351: end if;
352: dbms_pipe.pack_message (tmpstr);
353: if (arg_12 = CHR(0)) then goto end_pack; end if;
354: tmpstr := substr(arg_12, 1, fnd_transaction.ARGMAX);
355: argtotal := argtotal + length(tmpstr);
356: if argtotal > fnd_transaction.ARGSTOTAL then

Line 359: dbms_pipe.pack_message (tmpstr);

355: argtotal := argtotal + length(tmpstr);
356: if argtotal > fnd_transaction.ARGSTOTAL then
357: raise argslen_err;
358: end if;
359: dbms_pipe.pack_message (tmpstr);
360: if (arg_13 = CHR(0)) then goto end_pack; end if;
361: tmpstr := substr(arg_13, 1, fnd_transaction.ARGMAX);
362: argtotal := argtotal + length(tmpstr);
363: if argtotal > fnd_transaction.ARGSTOTAL then

Line 366: dbms_pipe.pack_message (tmpstr);

362: argtotal := argtotal + length(tmpstr);
363: if argtotal > fnd_transaction.ARGSTOTAL then
364: raise argslen_err;
365: end if;
366: dbms_pipe.pack_message (tmpstr);
367: if (arg_14 = CHR(0)) then goto end_pack; end if;
368: tmpstr := substr(arg_14, 1, fnd_transaction.ARGMAX);
369: argtotal := argtotal + length(tmpstr);
370: if argtotal > fnd_transaction.ARGSTOTAL then

Line 373: dbms_pipe.pack_message (tmpstr);

369: argtotal := argtotal + length(tmpstr);
370: if argtotal > fnd_transaction.ARGSTOTAL then
371: raise argslen_err;
372: end if;
373: dbms_pipe.pack_message (tmpstr);
374: if (arg_15 = CHR(0)) then goto end_pack; end if;
375: tmpstr := substr(arg_15, 1, fnd_transaction.ARGMAX);
376: argtotal := argtotal + length(tmpstr);
377: if argtotal > fnd_transaction.ARGSTOTAL then

Line 380: dbms_pipe.pack_message (tmpstr);

376: argtotal := argtotal + length(tmpstr);
377: if argtotal > fnd_transaction.ARGSTOTAL then
378: raise argslen_err;
379: end if;
380: dbms_pipe.pack_message (tmpstr);
381: if (arg_16 = CHR(0)) then goto end_pack; end if;
382: tmpstr := substr(arg_16, 1, fnd_transaction.ARGMAX);
383: argtotal := argtotal + length(tmpstr);
384: if argtotal > fnd_transaction.ARGSTOTAL then

Line 387: dbms_pipe.pack_message (tmpstr);

383: argtotal := argtotal + length(tmpstr);
384: if argtotal > fnd_transaction.ARGSTOTAL then
385: raise argslen_err;
386: end if;
387: dbms_pipe.pack_message (tmpstr);
388: if (arg_17 = CHR(0)) then goto end_pack; end if;
389: tmpstr := substr(arg_17, 1, fnd_transaction.ARGMAX);
390: argtotal := argtotal + length(tmpstr);
391: if argtotal > fnd_transaction.ARGSTOTAL then

Line 394: dbms_pipe.pack_message (tmpstr);

390: argtotal := argtotal + length(tmpstr);
391: if argtotal > fnd_transaction.ARGSTOTAL then
392: raise argslen_err;
393: end if;
394: dbms_pipe.pack_message (tmpstr);
395: if (arg_18 = CHR(0)) then goto end_pack; end if;
396: tmpstr := substr(arg_18, 1, fnd_transaction.ARGMAX);
397: argtotal := argtotal + length(tmpstr);
398: if argtotal > fnd_transaction.ARGSTOTAL then

Line 401: dbms_pipe.pack_message (tmpstr);

397: argtotal := argtotal + length(tmpstr);
398: if argtotal > fnd_transaction.ARGSTOTAL then
399: raise argslen_err;
400: end if;
401: dbms_pipe.pack_message (tmpstr);
402: if (arg_19 = CHR(0)) then goto end_pack; end if;
403: tmpstr := substr(arg_19, 1, fnd_transaction.ARGMAX);
404: argtotal := argtotal + length(tmpstr);
405: if argtotal > fnd_transaction.ARGSTOTAL then

Line 408: dbms_pipe.pack_message (tmpstr);

404: argtotal := argtotal + length(tmpstr);
405: if argtotal > fnd_transaction.ARGSTOTAL then
406: raise argslen_err;
407: end if;
408: dbms_pipe.pack_message (tmpstr);
409: if (arg_20 = CHR(0)) then goto end_pack; end if;
410: tmpstr := substr(arg_20, 1, fnd_transaction.ARGMAX);
411: argtotal := argtotal + length(tmpstr);
412: if argtotal > fnd_transaction.ARGSTOTAL then

Line 415: dbms_pipe.pack_message (tmpstr);

411: argtotal := argtotal + length(tmpstr);
412: if argtotal > fnd_transaction.ARGSTOTAL then
413: raise argslen_err;
414: end if;
415: dbms_pipe.pack_message (tmpstr);
416:
417: <>
418:
419:

Line 425: status := dbms_pipe.send_message(tm_pipe, remaining_time);

421: submit_time := sysdate;
422: remaining_time := timeout;
423:
424: -- Send the message. Exit on timeout or error.
425: status := dbms_pipe.send_message(tm_pipe, remaining_time);
426: if (status = 1) then
427: fnd_transaction.debug_info('fnd_trn_pipe.send_message', 'send_message timeout', NULL);
428:
429: /* mark timeout event (4) */

Line 448: dbms_pipe.reset_buffer;

444: -- 906219 - added call to reset_buffer here to clear the buffer
445: -- before receiving the message.
446: -- Leftover data in the buffer was causing messages to come out incorrect.
447: -- Also added calls in FNDCP_TMSRV
448: dbms_pipe.reset_buffer;
449:
450: -- Wait on return pipe. Exit on timoeout or error
451: status := dbms_pipe.receive_message(return_pipe, remaining_time);
452: if (status = 1) then

Line 451: status := dbms_pipe.receive_message(return_pipe, remaining_time);

447: -- Also added calls in FNDCP_TMSRV
448: dbms_pipe.reset_buffer;
449:
450: -- Wait on return pipe. Exit on timoeout or error
451: status := dbms_pipe.receive_message(return_pipe, remaining_time);
452: if (status = 1) then
453: fnd_transaction.debug_info('fnd_trn_pipe.send_message', 'receive_message timeout', NULL, 'U');
454:
455: /* mark timeout event (4) */

Line 465: if (dbms_pipe.next_item_type = 9) then

461: raise error;
462: end if;
463:
464: -- Exit loop only if we got the proper response
465: if (dbms_pipe.next_item_type = 9) then
466: dbms_pipe.unpack_message(tmpstr); -- Discard return type
467: if (dbms_pipe.next_item_type = 6) then
468: dbms_pipe.unpack_message(return_request_id);
469: exit when (request_id = return_request_id);

Line 466: dbms_pipe.unpack_message(tmpstr); -- Discard return type

462: end if;
463:
464: -- Exit loop only if we got the proper response
465: if (dbms_pipe.next_item_type = 9) then
466: dbms_pipe.unpack_message(tmpstr); -- Discard return type
467: if (dbms_pipe.next_item_type = 6) then
468: dbms_pipe.unpack_message(return_request_id);
469: exit when (request_id = return_request_id);
470: end if;

Line 467: if (dbms_pipe.next_item_type = 6) then

463:
464: -- Exit loop only if we got the proper response
465: if (dbms_pipe.next_item_type = 9) then
466: dbms_pipe.unpack_message(tmpstr); -- Discard return type
467: if (dbms_pipe.next_item_type = 6) then
468: dbms_pipe.unpack_message(return_request_id);
469: exit when (request_id = return_request_id);
470: end if;
471: end if;

Line 468: dbms_pipe.unpack_message(return_request_id);

464: -- Exit loop only if we got the proper response
465: if (dbms_pipe.next_item_type = 9) then
466: dbms_pipe.unpack_message(tmpstr); -- Discard return type
467: if (dbms_pipe.next_item_type = 6) then
468: dbms_pipe.unpack_message(return_request_id);
469: exit when (request_id = return_request_id);
470: end if;
471: end if;
472: end loop;

Line 475: dbms_pipe.unpack_message(outcome);

471: end if;
472: end loop;
473:
474: -- Unpack return arguments
475: dbms_pipe.unpack_message(outcome);
476: dbms_pipe.unpack_message(message);
477:
478: -- Populate return value table
479: for counter in 1..21 loop

Line 476: dbms_pipe.unpack_message(message);

472: end loop;
473:
474: -- Unpack return arguments
475: dbms_pipe.unpack_message(outcome);
476: dbms_pipe.unpack_message(message);
477:
478: -- Populate return value table
479: for counter in 1..21 loop
480: counter1 := counter;

Line 481: exit when dbms_pipe.next_item_type <> 9;

477:
478: -- Populate return value table
479: for counter in 1..21 loop
480: counter1 := counter;
481: exit when dbms_pipe.next_item_type <> 9;
482: dbms_pipe.unpack_message(return_val);
483: fnd_transaction.return_values(counter) := return_val;
484: end loop;
485:

Line 482: dbms_pipe.unpack_message(return_val);

478: -- Populate return value table
479: for counter in 1..21 loop
480: counter1 := counter;
481: exit when dbms_pipe.next_item_type <> 9;
482: dbms_pipe.unpack_message(return_val);
483: fnd_transaction.return_values(counter) := return_val;
484: end loop;
485:
486: -- Null out the unused table elements