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 978: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

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

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

996: else
997: l_dequeue_options.correlation := WF_EVENT.g_correlation;
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;

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

1020:
1021: wf_event.navigation := dbms_aq.next_message;
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;

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

1066:
1067: -- set the msgid to the event
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;