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.4.12020000.5 2013/04/09 17:15:14 skandepu 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 981: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.Begin',

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

Line 1031: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.corrid',

1027:
1028: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1029: if (wf_event.g_correlation is not null) then
1030: wf_log_pkg.string(wf_log_pkg.level_procedure,
1031: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.corrid',
1032: 'Dequeuing with Correlation:' || l_dequeue_options.correlation);
1033: else
1034: wf_log_pkg.string(wf_log_pkg.level_procedure,
1035: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.corrid',

Line 1035: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.corrid',

1031: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.corrid',
1032: 'Dequeuing with Correlation:' || l_dequeue_options.correlation);
1033: else
1034: wf_log_pkg.string(wf_log_pkg.level_procedure,
1035: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.corrid',
1036: 'Dequeuing with dequeue condition:' || l_dequeue_options.deq_condition);
1037: end if;
1038: end if;
1039:

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

1052: exception
1053: when no_messages then
1054: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
1055: wf_log_pkg.string(wf_log_pkg.level_event,
1056: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.queue_empty',
1057: 'No more messages in dequeue.');
1058: end if;
1059:
1060: -- reset navigation

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

1091: p_event.addparametertolist('#MSG_ID', l_msgid);
1092:
1093: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1094: wf_log_pkg.string(wf_log_pkg.level_procedure,
1095: 'wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.End',
1096: 'Finished');
1097: end if;
1098:
1099: exception

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

1097: end if;
1098:
1099: exception
1100: when others then
1101: wf_core.context('WF_EVENT_OJMSTEXT_QH', 'Dequeue', l_queue_name,
1102: 'SQL error is ' || substr(sqlerrm, 1, 200));
1103: raise;
1104: end dequeue;
1105:

Line 1106: end wf_event_ojmstext_qh;

1102: 'SQL error is ' || substr(sqlerrm, 1, 200));
1103: raise;
1104: end dequeue;
1105:
1106: end wf_event_ojmstext_qh;