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 dependencies on FND_TRANSACTION

Line 1: package body fnd_transaction as

1: package body fnd_transaction as
2: /* $Header: AFCPTRNB.pls 120.10 2011/04/04 20:08:27 pferguso ship $ */
3:
4:
5: --

Line 349: debug_info('fnd_transaction.synchronous', 'Starting transaction', NULL);

345:
346: initialize_globals;
347:
348: if (debug_flag) then
349: debug_info('fnd_transaction.synchronous', 'Starting transaction', NULL);
350: end if;
351:
352: if (timeout <= 0 or timeout is null) then
353: fnd_message.set_name('FND', 'CONC-TM-Invalid timeout');

Line 354: debug_info('fnd_transaction.synchronous', 'Invalid timeout parameter', to_char(timeout));

350: end if;
351:
352: if (timeout <= 0 or timeout is null) then
353: fnd_message.set_name('FND', 'CONC-TM-Invalid timeout');
354: debug_info('fnd_transaction.synchronous', 'Invalid timeout parameter', to_char(timeout));
355: raise error;
356: end if;
357:
358: if (application is null) then

Line 360: debug_info('fnd_transaction.synchronous', 'NULL application parameter', NULL);

356: end if;
357:
358: if (application is null) then
359: fnd_message.set_name('FND', 'CONC-TM-Application null');
360: debug_info('fnd_transaction.synchronous', 'NULL application parameter', NULL);
361: raise error;
362: end if;
363:
364: if (program is null) then

Line 366: debug_info('fnd_transaction.synchronous', 'NULL program parameter', NULL);

362: end if;
363:
364: if (program is null) then
365: fnd_message.set_name('FND', 'CONC-TM-Program null');
366: debug_info('fnd_transaction.synchronous', 'NULL program parameter', NULL);
367: raise error;
368: end if;
369:
370: if (debug_flag) then

Line 371: debug_info('fnd_transaction.synchronous', 'Using transport type', p_transport_type);

367: raise error;
368: end if;
369:
370: if (debug_flag) then
371: debug_info('fnd_transaction.synchronous', 'Using transport type', p_transport_type);
372: end if;
373:
374: -- Get SQL_TRACE MULTI_ORG_CATEGORY
375: fnd_profile.get('SQL_TRACE', enable_trace_flag);

Line 390: status := fnd_transaction_pipe.get_manager(application, program, token_timeout);

386: and a.application_short_name = application;
387:
388: -- Get manager
389: if p_transport_type = 'PIPE' then
390: status := fnd_transaction_pipe.get_manager(application, program, token_timeout);
391: else
392: status := fnd_transaction_queue.get_manager(application, program, token_timeout);
393: end if;
394:

Line 392: status := fnd_transaction_queue.get_manager(application, program, token_timeout);

388: -- Get manager
389: if p_transport_type = 'PIPE' then
390: status := fnd_transaction_pipe.get_manager(application, program, token_timeout);
391: else
392: status := fnd_transaction_queue.get_manager(application, program, token_timeout);
393: end if;
394:
395: if status = E_NOMGR then -- All managers busy
396: return status;

Line 433: debug_info('fnd_transaction.synchronous',

429: -- Request expires at SYSDATE + timeout
430: expiration_time := sysdate + (timeout * DAY_PER_SEC);
431:
432: if (debug_flag) then
433: debug_info('fnd_transaction.synchronous',
434: 'REQID:SECID:TRACE:EXPIRES',
435: to_char(request_id) || ':' || to_char(secgrpid) || ':'
436: || enable_trace_flag || ':' || to_char(expiration_time, 'DD-MON-RR HH24:MI:SS'));
437: debug_info('fnd_transaction.synchronous',

Line 437: debug_info('fnd_transaction.synchronous',

433: debug_info('fnd_transaction.synchronous',
434: 'REQID:SECID:TRACE:EXPIRES',
435: to_char(request_id) || ':' || to_char(secgrpid) || ':'
436: || enable_trace_flag || ':' || to_char(expiration_time, 'DD-MON-RR HH24:MI:SS'));
437: debug_info('fnd_transaction.synchronous',
438: 'NLS_LANG:DATE_LANG:NUM_CHARS',
439: nls_lang || ':' || nls_date_lang || ':' || nls_num_chars);
440:
441:

Line 442: debug_info('fnd_transaction.synchronous',

438: 'NLS_LANG:DATE_LANG:NUM_CHARS',
439: nls_lang || ':' || nls_date_lang || ':' || nls_num_chars);
440:
441:
442: debug_info('fnd_transaction.synchronous',
443: 'Packing packet type',
444: send_type);
445: debug_info('fnd_transaction.synchronous',
446: 'Packing program application',

Line 445: debug_info('fnd_transaction.synchronous',

441:
442: debug_info('fnd_transaction.synchronous',
443: 'Packing packet type',
444: send_type);
445: debug_info('fnd_transaction.synchronous',
446: 'Packing program application',
447: application);
448: debug_info('fnd_transaction.synchronous',
449: 'Packing program',

Line 448: debug_info('fnd_transaction.synchronous',

444: send_type);
445: debug_info('fnd_transaction.synchronous',
446: 'Packing program application',
447: application);
448: debug_info('fnd_transaction.synchronous',
449: 'Packing program',
450: program);
451: debug_info('fnd_transaction.synchronous',
452: 'Packing org_type',

Line 451: debug_info('fnd_transaction.synchronous',

447: application);
448: debug_info('fnd_transaction.synchronous',
449: 'Packing program',
450: program);
451: debug_info('fnd_transaction.synchronous',
452: 'Packing org_type',
453: org_type);
454: debug_info('fnd_transaction.synchronous',
455: 'Packing org_id',

Line 454: debug_info('fnd_transaction.synchronous',

450: program);
451: debug_info('fnd_transaction.synchronous',
452: 'Packing org_type',
453: org_type);
454: debug_info('fnd_transaction.synchronous',
455: 'Packing org_id',
456: org_id);
457: if (arg_1 = CHR(0)) then goto end_dbg; end if;
458: debug_info('fnd_transaction.synchronous',

Line 458: debug_info('fnd_transaction.synchronous',

454: debug_info('fnd_transaction.synchronous',
455: 'Packing org_id',
456: org_id);
457: if (arg_1 = CHR(0)) then goto end_dbg; end if;
458: debug_info('fnd_transaction.synchronous',
459: 'Packing arg 1',
460: arg_1);
461: if (arg_2 = CHR(0)) then goto end_dbg; end if;
462: debug_info('fnd_transaction.synchronous',

Line 462: debug_info('fnd_transaction.synchronous',

458: debug_info('fnd_transaction.synchronous',
459: 'Packing arg 1',
460: arg_1);
461: if (arg_2 = CHR(0)) then goto end_dbg; end if;
462: debug_info('fnd_transaction.synchronous',
463: 'Packing arg 2',
464: arg_2);
465: if (arg_3 = CHR(0)) then goto end_dbg; end if;
466: debug_info('fnd_transaction.synchronous',

Line 466: debug_info('fnd_transaction.synchronous',

462: debug_info('fnd_transaction.synchronous',
463: 'Packing arg 2',
464: arg_2);
465: if (arg_3 = CHR(0)) then goto end_dbg; end if;
466: debug_info('fnd_transaction.synchronous',
467: 'Packing arg 3',
468: arg_3);
469: if (arg_4 = CHR(0)) then goto end_dbg; end if;
470: debug_info('fnd_transaction.synchronous',

Line 470: debug_info('fnd_transaction.synchronous',

466: debug_info('fnd_transaction.synchronous',
467: 'Packing arg 3',
468: arg_3);
469: if (arg_4 = CHR(0)) then goto end_dbg; end if;
470: debug_info('fnd_transaction.synchronous',
471: 'Packing arg 4',
472: arg_4);
473: if (arg_5 = CHR(0)) then goto end_dbg; end if;
474: debug_info('fnd_transaction.synchronous',

Line 474: debug_info('fnd_transaction.synchronous',

470: debug_info('fnd_transaction.synchronous',
471: 'Packing arg 4',
472: arg_4);
473: if (arg_5 = CHR(0)) then goto end_dbg; end if;
474: debug_info('fnd_transaction.synchronous',
475: 'Packing arg 5',
476: arg_5);
477: if (arg_6 = CHR(0)) then goto end_dbg; end if;
478: debug_info('fnd_transaction.synchronous',

Line 478: debug_info('fnd_transaction.synchronous',

474: debug_info('fnd_transaction.synchronous',
475: 'Packing arg 5',
476: arg_5);
477: if (arg_6 = CHR(0)) then goto end_dbg; end if;
478: debug_info('fnd_transaction.synchronous',
479: 'Packing arg 6',
480: arg_6);
481: if (arg_7 = CHR(0)) then goto end_dbg; end if;
482: debug_info('fnd_transaction.synchronous',

Line 482: debug_info('fnd_transaction.synchronous',

478: debug_info('fnd_transaction.synchronous',
479: 'Packing arg 6',
480: arg_6);
481: if (arg_7 = CHR(0)) then goto end_dbg; end if;
482: debug_info('fnd_transaction.synchronous',
483: 'Packing arg 7',
484: arg_7);
485: if (arg_8 = CHR(0)) then goto end_dbg; end if;
486: debug_info('fnd_transaction.synchronous',

Line 486: debug_info('fnd_transaction.synchronous',

482: debug_info('fnd_transaction.synchronous',
483: 'Packing arg 7',
484: arg_7);
485: if (arg_8 = CHR(0)) then goto end_dbg; end if;
486: debug_info('fnd_transaction.synchronous',
487: 'Packing arg 8',
488: arg_8);
489: if (arg_9 = CHR(0)) then goto end_dbg; end if;
490: debug_info('fnd_transaction.synchronous',

Line 490: debug_info('fnd_transaction.synchronous',

486: debug_info('fnd_transaction.synchronous',
487: 'Packing arg 8',
488: arg_8);
489: if (arg_9 = CHR(0)) then goto end_dbg; end if;
490: debug_info('fnd_transaction.synchronous',
491: 'Packing arg 9',
492: arg_9);
493: if (arg_10 = CHR(0)) then goto end_dbg; end if;
494: debug_info('fnd_transaction.synchronous',

Line 494: debug_info('fnd_transaction.synchronous',

490: debug_info('fnd_transaction.synchronous',
491: 'Packing arg 9',
492: arg_9);
493: if (arg_10 = CHR(0)) then goto end_dbg; end if;
494: debug_info('fnd_transaction.synchronous',
495: 'Packing arg 10',
496: arg_10);
497: if (arg_11 = CHR(0)) then goto end_dbg; end if;
498: debug_info('fnd_transaction.synchronous',

Line 498: debug_info('fnd_transaction.synchronous',

494: debug_info('fnd_transaction.synchronous',
495: 'Packing arg 10',
496: arg_10);
497: if (arg_11 = CHR(0)) then goto end_dbg; end if;
498: debug_info('fnd_transaction.synchronous',
499: 'Packing arg 11',
500: arg_11);
501: if (arg_12 = CHR(0)) then goto end_dbg; end if;
502: debug_info('fnd_transaction.synchronous',

Line 502: debug_info('fnd_transaction.synchronous',

498: debug_info('fnd_transaction.synchronous',
499: 'Packing arg 11',
500: arg_11);
501: if (arg_12 = CHR(0)) then goto end_dbg; end if;
502: debug_info('fnd_transaction.synchronous',
503: 'Packing arg 12',
504: arg_12);
505: if (arg_13 = CHR(0)) then goto end_dbg; end if;
506: debug_info('fnd_transaction.synchronous',

Line 506: debug_info('fnd_transaction.synchronous',

502: debug_info('fnd_transaction.synchronous',
503: 'Packing arg 12',
504: arg_12);
505: if (arg_13 = CHR(0)) then goto end_dbg; end if;
506: debug_info('fnd_transaction.synchronous',
507: 'Packing arg 13',
508: arg_13);
509: if (arg_14 = CHR(0)) then goto end_dbg; end if;
510: debug_info('fnd_transaction.synchronous',

Line 510: debug_info('fnd_transaction.synchronous',

506: debug_info('fnd_transaction.synchronous',
507: 'Packing arg 13',
508: arg_13);
509: if (arg_14 = CHR(0)) then goto end_dbg; end if;
510: debug_info('fnd_transaction.synchronous',
511: 'Packing arg 14',
512: arg_14);
513: if (arg_15 = CHR(0)) then goto end_dbg; end if;
514: debug_info('fnd_transaction.synchronous',

Line 514: debug_info('fnd_transaction.synchronous',

510: debug_info('fnd_transaction.synchronous',
511: 'Packing arg 14',
512: arg_14);
513: if (arg_15 = CHR(0)) then goto end_dbg; end if;
514: debug_info('fnd_transaction.synchronous',
515: 'Packing arg 15',
516: arg_15);
517: if (arg_16 = CHR(0)) then goto end_dbg; end if;
518: debug_info('fnd_transaction.synchronous',

Line 518: debug_info('fnd_transaction.synchronous',

514: debug_info('fnd_transaction.synchronous',
515: 'Packing arg 15',
516: arg_15);
517: if (arg_16 = CHR(0)) then goto end_dbg; end if;
518: debug_info('fnd_transaction.synchronous',
519: 'Packing arg 16',
520: arg_16);
521: if (arg_17 = CHR(0)) then goto end_dbg; end if;
522: debug_info('fnd_transaction.synchronous',

Line 522: debug_info('fnd_transaction.synchronous',

518: debug_info('fnd_transaction.synchronous',
519: 'Packing arg 16',
520: arg_16);
521: if (arg_17 = CHR(0)) then goto end_dbg; end if;
522: debug_info('fnd_transaction.synchronous',
523: 'Packing arg 17',
524: arg_17);
525: if (arg_18 = CHR(0)) then goto end_dbg; end if;
526: debug_info('fnd_transaction.synchronous',

Line 526: debug_info('fnd_transaction.synchronous',

522: debug_info('fnd_transaction.synchronous',
523: 'Packing arg 17',
524: arg_17);
525: if (arg_18 = CHR(0)) then goto end_dbg; end if;
526: debug_info('fnd_transaction.synchronous',
527: 'Packing arg 18',
528: arg_18);
529: if (arg_19 = CHR(0)) then goto end_dbg; end if;
530: debug_info('fnd_transaction.synchronous',

Line 530: debug_info('fnd_transaction.synchronous',

526: debug_info('fnd_transaction.synchronous',
527: 'Packing arg 18',
528: arg_18);
529: if (arg_19 = CHR(0)) then goto end_dbg; end if;
530: debug_info('fnd_transaction.synchronous',
531: 'Packing arg 19',
532: arg_19);
533: if (arg_20 = CHR(0)) then goto end_dbg; end if;
534: debug_info('fnd_transaction.synchronous',

Line 534: debug_info('fnd_transaction.synchronous',

530: debug_info('fnd_transaction.synchronous',
531: 'Packing arg 19',
532: arg_19);
533: if (arg_20 = CHR(0)) then goto end_dbg; end if;
534: debug_info('fnd_transaction.synchronous',
535: 'Packing arg 20',
536: arg_20);
537:
538: <>

Line 539: debug_info('fnd_transaction.synchronous', 'Timeout value', to_char(timeout));

535: 'Packing arg 20',
536: arg_20);
537:
538: <>
539: debug_info('fnd_transaction.synchronous', 'Timeout value', to_char(timeout));
540: end if;
541:
542:
543: if p_transport_type = 'PIPE' then

Line 544: status := fnd_transaction_pipe.send_message(timeout, send_type, expiration_time, request_id,

540: end if;
541:
542:
543: if p_transport_type = 'PIPE' then
544: status := fnd_transaction_pipe.send_message(timeout, send_type, expiration_time, request_id,
545: nls_lang, nls_num_chars, nls_date_lang,
546: secgrpid, enable_trace_flag, application, program,
547: org_type, org_id, outcome, message,
548: arg_1, arg_2, arg_3, arg_4, arg_5,

Line 554: status := fnd_transaction_queue.send_message(timeout, send_type, expiration_time, request_id,

550: arg_11, arg_12, arg_13, arg_14, arg_15,
551: arg_16, arg_17, arg_18, arg_19, arg_20);
552:
553: else
554: status := fnd_transaction_queue.send_message(timeout, send_type, expiration_time, request_id,
555: nls_lang, nls_num_chars, nls_date_lang,
556: secgrpid, enable_trace_flag, application, program,
557: org_type, org_id, outcome, message,
558: arg_1, arg_2, arg_3, arg_4, arg_5,

Line 566: debug_info('fnd_transaction.synchronous', 'Transaction complete', request_id, 'U');

562: end if;
563:
564:
565: if (debug_flag) then
566: debug_info('fnd_transaction.synchronous', 'Transaction complete', request_id, 'U');
567: end if;
568:
569: return status;
570:

Line 580: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION.SYNCHRONOUS', FALSE);

576: when OTHERS then
577: fnd_message.set_name ('FND', 'SQL-Generic error');
578: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
579: fnd_message.set_token ('REASON', sqlerrm, FALSE);
580: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION.SYNCHRONOUS', FALSE);
581: debug_info('fnd_transaction.synchronous', 'Caught exception', sqlerrm);
582: return E_OTHER;
583:
584: end synchronous;

Line 581: debug_info('fnd_transaction.synchronous', 'Caught exception', sqlerrm);

577: fnd_message.set_name ('FND', 'SQL-Generic error');
578: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
579: fnd_message.set_token ('REASON', sqlerrm, FALSE);
580: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION.SYNCHRONOUS', FALSE);
581: debug_info('fnd_transaction.synchronous', 'Caught exception', sqlerrm);
582: return E_OTHER;
583:
584: end synchronous;
585:

Line 651: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION.GET_VALUES', FALSE);

647: when others then
648: fnd_message.set_name ('FND', 'SQL-Generic error');
649: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
650: fnd_message.set_token ('REASON', sqlerrm, FALSE);
651: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION.GET_VALUES', FALSE);
652: return E_OTHER;
653: end get_values;
654:
655:

Line 658: end fnd_transaction;

654:
655:
656:
657:
658: end fnd_transaction;