DBA Data[Home] [Help]

APPS.WF_EVENT_OJMSTEXT_QH dependencies on FND_LOG

Line 823: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

819:
820: -- set the delay if required; also used for deferred agent
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;

Line 831: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

827: end if;
828:
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;

Line 859: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

855: l_delay := p_event.getValueForParameter ('#MSG_DELAY');
856:
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,

Line 916: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

912: l_message_properties.correlation := l_q_correlation_id;
913: end if;
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;

Line 931: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

927:
928: -- Storing the enqueue msgid, similar to that been done WF_EVENT_QH
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;

Line 979: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

975: l_agent_name
976: from wf_agents
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;

Line 1014: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1010: l_dequeue_options.correlation := null;
1011: -- Get the dedicated components correlation Id list
1012: l_corrId_list := WF_CORE.getDedicatedComponentsCorrIds(l_agent_name, wf_event.account_name);
1013:
1014: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1015: wf_log_pkg.string(wf_log_pkg.level_statement,
1016: 'wf.plsql.WF_EVENT_QH.dequeue.corr',
1017: 'The dedicated components correlation ids list is:' || l_corrId_list);
1018: end if;

Line 1028: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1024: end if;
1025:
1026: end if;
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);

Line 1054: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

1050: msgid => l_msgid); -- out
1051:
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;

Line 1093: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1089:
1090: -- set the msgid to the event
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;