140:
141: else
142: cmd := '
143: p_event.getEventKey()||'
144: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);
145: dbms_lob.write(msg, length(cmd), 1, cmd);
146: end if;
147:
148: p_event.event_data := msg ;
141: else
142: cmd := '
143: p_event.getEventKey()||'
144: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);
145: dbms_lob.write(msg, length(cmd), 1, cmd);
146: end if;
147:
148: p_event.event_data := msg ;
149: -- p_event.setEventData(msg);
618: -- Exception happened in Generate Method should be thrown
619: -- up.
620: --
621: -- mjc Check if we are required to Generate Message
622: -- Use dbms_lob.istemporary to see if any clob
623: --
624: begin
625: if (NOT genmsg) AND
626: (p_rule_data = 'MESSAGE') AND
629: wf_log_pkg.string(wf_log_pkg.level_statement,
630: 'wf.plsql.WF_EVENT.dispatch_internal.Rule_Data',
631: 'Rule Data is MESSAGE and Source is LOCAL');
632: end if;
633: -- if dbms_lob.istemporary(p_event.GetEventData()) = 0 then
634: -- Bug Fix for 4286207
635: begin
636: if (p_event.GetEventData() is null) or
637: (p_event.GetEventData() is not null and dbms_lob.getlength(p_event.GetEventData()) = 0) then
633: -- if dbms_lob.istemporary(p_event.GetEventData()) = 0 then
634: -- Bug Fix for 4286207
635: begin
636: if (p_event.GetEventData() is null) or
637: (p_event.GetEventData() is not null and dbms_lob.getlength(p_event.GetEventData()) = 0) then
638: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
639: wf_log_pkg.string(wf_log_pkg.level_statement,
640: 'wf.plsql.WF_EVENT.dispatch_internal.generate',
641: 'Need to Generate Message');