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.WF_EVENT_OJMSTEXT_QH dependencies on WF_EVENT_OJMSTEXT_QH

Line 1: package body wf_event_ojmstext_qh as

1: package body wf_event_ojmstext_qh as
2: /* $Header: wfjmstxb.pls 120.2.12000000.2 2007/07/03 03:59:57 sstomar ship $ */
3:
4: DATE_MASK constant varchar2(21) := 'YYYY/MM/DD HH24:MI:SS';
5: DEFAULT_PRIORITY constant int := 100;

Line 566: wf_core.context('WF_EVENT_OJMSTEXT_QH', 'serialize',

562:
563: set_text(p_jms_text_message, p_event.getEventData());
564:
565: exception when others then
566: wf_core.context('WF_EVENT_OJMSTEXT_QH', 'serialize',
567: 'SQL error is ' || substr(sqlerrm, 1, 200));
568: raise;
569: end serialize;
570:

Line 825: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay',

821:
822: if(p_event.getSendDate() > sysdate) then
823: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
824: wf_log_pkg.string(wf_log_pkg.level_statement,
825: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay',
826: 'Delay Detected');
827: end if;
828:
829: l_delay := (p_event.getSendDate() - sysdate)*24*60*60;

Line 833: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay_time',

829: l_delay := (p_event.getSendDate() - sysdate)*24*60*60;
830:
831: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
832: wf_log_pkg.string(wf_log_pkg.level_statement,
833: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay_time',
834: 'delay = ' || to_char(l_delay));
835: end if;
836:
837: if(l_delay > 1) then

Line 861: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay',

857: if (l_delay is not NULL) then
858:
859: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
860: wf_log_pkg.string(wf_log_pkg.level_statement,
861: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay',
862: 'Delay Detected');
863: wf_log_pkg.string(wf_log_pkg.level_statement,
864: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay_time',
865: 'delay = ' || to_char(l_delay));

Line 864: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay_time',

860: wf_log_pkg.string(wf_log_pkg.level_statement,
861: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay',
862: 'Delay Detected');
863: wf_log_pkg.string(wf_log_pkg.level_statement,
864: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.delay_time',
865: 'delay = ' || to_char(l_delay));
866: end if;
867:
868:

Line 918: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.dbms_aq',

914: END IF;
915:
916: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
917: wf_log_pkg.string(wf_log_pkg.level_statement,
918: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.dbms_aq',
919: 'Calling dbms_aq.enqueue');
920: end if;
921:
922: dbms_aq.enqueue(queue_name => l_out_queue_name,

Line 933: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.End',

929: WF_EVENT.g_msgid := l_msgid;
930:
931: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
932: wf_log_pkg.string(wf_log_pkg.level_procedure,
933: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.enqueue.End',
934: 'Finished calling dbms_aq.enqueue');
935: end if;
936:
937: exception

Line 939: wf_core.context('WF_EVENT_OJMSTEXT_QH', 'enqueue', l_out_queue_name,

935: end if;
936:
937: exception
938: when others then
939: wf_core.context('WF_EVENT_OJMSTEXT_QH', 'enqueue', l_out_queue_name,
940: 'SQL error is ' || substr(sqlerrm, 1, 200));
941: raise;
942: end enqueue;
943:

Line 980: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.Begin',

976: where guid = p_agent_guid;
977:
978: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
979: wf_log_pkg.string(wf_log_pkg.level_procedure,
980: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.Begin',
981: 'Dequeuing '||l_queue_name||' on '||l_agent_name);
982: end if;
983:
984: -- Set correlation if the g_correlation is not null

Line 1002: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.corr',

998: end if;
999:
1000: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1001: wf_log_pkg.string(wf_log_pkg.level_statement,
1002: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.corr',
1003: 'Setting correlation: ' || l_dequeue_options.correlation);
1004: end if;
1005:
1006: END IF;

Line 1026: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.queue_empty',

1022: exception
1023: when no_messages then
1024: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
1025: wf_log_pkg.string(wf_log_pkg.level_event,
1026: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.queue_empty',
1027: 'No more messages in dequeue.');
1028: end if;
1029:
1030: wf_event.navigation := dbms_aq.first_message;

Line 1072: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.End',

1068: p_event.addparametertolist('#MSG_ID', l_msgid);
1069:
1070: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1071: wf_log_pkg.string(wf_log_pkg.level_procedure,
1072: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.End',
1073: 'Finished');
1074: end if;
1075:
1076: exception

Line 1078: wf_core.context('WF_EVENT_OJMSTEXT_QH', 'Dequeue', l_queue_name,

1074: end if;
1075:
1076: exception
1077: when others then
1078: wf_core.context('WF_EVENT_OJMSTEXT_QH', 'Dequeue', l_queue_name,
1079: 'SQL error is ' || substr(sqlerrm, 1, 200));
1080: raise;
1081: end dequeue;
1082:

Line 1083: end wf_event_ojmstext_qh;

1079: 'SQL error is ' || substr(sqlerrm, 1, 200));
1080: raise;
1081: end dequeue;
1082:
1083: end wf_event_ojmstext_qh;