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_RULE dependencies on WF_LOG_PKG

Line 43: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_rule.log.begin',

39: -- works ok
40: offset number;
41:
42: begin
43: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_rule.log.begin',
44: 'Begin wf_rule.log rule function');
45:
46: if (p_event is null) then
47: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_null',

Line 47: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_null',

43: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_rule.log.begin',
44: 'Begin wf_rule.log rule function');
45:
46: if (p_event is null) then
47: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_null',
48: 'Event is null. Returning.');
49: return 'SUCCESS';
50: end if;
51:

Line 52: -- Reimplementation with wf_log_pkg

48: 'Event is null. Returning.');
49: return 'SUCCESS';
50: end if;
51:
52: -- Reimplementation with wf_log_pkg
53:
54: if (p_event.getFromAgent() is not null) then
55: -- Log message only
56: -- BINDVAR_SCAN_IGNORE[2]

Line 57: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.from_agent',

53:
54: if (p_event.getFromAgent() is not null) then
55: -- Log message only
56: -- BINDVAR_SCAN_IGNORE[2]
57: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.from_agent',
58: 'From Agent Name: '||p_event.getFromAgent().getName());
59: -- BINDVAR_SCAN_IGNORE[2]
60: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.from_agent.from_agent_sys',
61: 'From Agent System: '||p_event.getFromAgent().getSystem());

Line 60: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.from_agent.from_agent_sys',

56: -- BINDVAR_SCAN_IGNORE[2]
57: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.from_agent',
58: 'From Agent Name: '||p_event.getFromAgent().getName());
59: -- BINDVAR_SCAN_IGNORE[2]
60: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.from_agent.from_agent_sys',
61: 'From Agent System: '||p_event.getFromAgent().getSystem());
62: end if;
63:
64: if (p_event.getToAgent() is not null) then

Line 65: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.to_agent',

61: 'From Agent System: '||p_event.getFromAgent().getSystem());
62: end if;
63:
64: if (p_event.getToAgent() is not null) then
65: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.to_agent',
66: 'To Agent Name: '||p_event.getToAgent().getName());
67: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.to_agent_sys',
68: 'To Agent System: '||p_event.getToAgent().getSystem());
69: end if;

Line 67: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.to_agent_sys',

63:
64: if (p_event.getToAgent() is not null) then
65: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.to_agent',
66: 'To Agent Name: '||p_event.getToAgent().getName());
67: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.to_agent_sys',
68: 'To Agent System: '||p_event.getToAgent().getSystem());
69: end if;
70:
71: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.priority',

Line 71: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.priority',

67: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.to_agent_sys',
68: 'To Agent System: '||p_event.getToAgent().getSystem());
69: end if;
70:
71: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.priority',
72: 'Priority: '||p_event.getPriority());
73: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.send_date',
74: 'Send Date: '||to_char(p_event.getSendDate(), wf_core.canonical_date_mask));
75: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.receive_date',

Line 73: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.send_date',

69: end if;
70:
71: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.priority',
72: 'Priority: '||p_event.getPriority());
73: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.send_date',
74: 'Send Date: '||to_char(p_event.getSendDate(), wf_core.canonical_date_mask));
75: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.receive_date',
76: 'Receive Date: '||to_char(p_event.getReceiveDate(), wf_core.canonical_date_mask));
77: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.corr_id',

Line 75: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.receive_date',

71: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.priority',
72: 'Priority: '||p_event.getPriority());
73: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.send_date',
74: 'Send Date: '||to_char(p_event.getSendDate(), wf_core.canonical_date_mask));
75: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.receive_date',
76: 'Receive Date: '||to_char(p_event.getReceiveDate(), wf_core.canonical_date_mask));
77: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.corr_id',
78: 'Correlation ID: '||p_event.getCorrelationID());
79:

Line 77: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.corr_id',

73: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.send_date',
74: 'Send Date: '||to_char(p_event.getSendDate(), wf_core.canonical_date_mask));
75: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.receive_date',
76: 'Receive Date: '||to_char(p_event.getReceiveDate(), wf_core.canonical_date_mask));
77: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.corr_id',
78: 'Correlation ID: '||p_event.getCorrelationID());
79:
80: parmlist := p_event.getParameterList();
81: if (parmlist is not null) then

Line 83: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.param_list',

79:
80: parmlist := p_event.getParameterList();
81: if (parmlist is not null) then
82: i := parmlist.FIRST;
83: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.param_list',
84: 'Begin Parameterlist');
85:
86: while (i <= parmlist.LAST) loop
87: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.param',

Line 87: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.param',

83: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.param_list',
84: 'Begin Parameterlist');
85:
86: while (i <= parmlist.LAST) loop
87: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.param',
88: 'Name: '||parmlist(i).getName()||' Value: '||parmlist(i).getValue());
89:
90: i := parmlist.NEXT(i);
91: end loop;

Line 92: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.param_list',

88: 'Name: '||parmlist(i).getName()||' Value: '||parmlist(i).getValue());
89:
90: i := parmlist.NEXT(i);
91: end loop;
92: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.param_list',
93: 'End Parameterlist');
94: end if;
95:
96: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_name',

Line 96: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_name',

92: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.param_list',
93: 'End Parameterlist');
94: end if;
95:
96: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_name',
97: 'Event Name: '||p_event.getEventName());
98: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_key',
99: 'Event Key: '||p_event.getEventKey());
100:

Line 98: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_key',

94: end if;
95:
96: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_name',
97: 'Event Name: '||p_event.getEventName());
98: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_key',
99: 'Event Key: '||p_event.getEventKey());
100:
101: select source_type into srctype from wf_event_subscriptions
102: where guid = p_subscription_guid;

Line 106: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.istemp',

102: where guid = p_subscription_guid;
103:
104: -- Need to check if clob is temporary instead of null
105: IsTmp := dbms_lob.istemporary(p_event.GetEventData());
106: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.istemp',
107: 'Event Data is Temp: '||IsTmp);
108: if ((IsTmp= 1 and srctype = 'LOCAL')
109: or (IsTmp= 0 and srctype in ('EXTERNAL','ERROR'))) then
110: wf_log_pkg.string(wf_log_pkg.level_statement,

Line 110: wf_log_pkg.string(wf_log_pkg.level_statement,

106: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.istemp',
107: 'Event Data is Temp: '||IsTmp);
108: if ((IsTmp= 1 and srctype = 'LOCAL')
109: or (IsTmp= 0 and srctype in ('EXTERNAL','ERROR'))) then
110: wf_log_pkg.string(wf_log_pkg.level_statement,
111: 'wf.plsql.wf_rule.log.event_data', 'Begin EventData');
112: myclob := p_event.getEventData();
113: if myclob is not null then
114: offset := 1;

Line 117: wf_log_pkg.string( wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.message',

113: if myclob is not null then
114: offset := 1;
115: clob_len := dbms_lob.getlength(myclob);
116: while( offset <= clob_len ) loop
117: wf_log_pkg.string( wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.message',
118: dbms_lob.substr( myclob, clob_bufsize, offset ));
119: offset := offset + clob_bufsize;
120: end loop;
121: end if;

Line 122: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_data', 'End EventData');

118: dbms_lob.substr( myclob, clob_bufsize, offset ));
119: offset := offset + clob_bufsize;
120: end loop;
121: end if;
122: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_data', 'End EventData');
123: else
124: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_data', 'Event Data is Empty');
125: end if;
126:

Line 124: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_data', 'Event Data is Empty');

120: end loop;
121: end if;
122: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_data', 'End EventData');
123: else
124: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_data', 'Event Data is Empty');
125: end if;
126:
127: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_sub',
128: 'Error Subscription: '||p_event.getErrorSubscription());

Line 127: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_sub',

123: else
124: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_data', 'Event Data is Empty');
125: end if;
126:
127: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_sub',
128: 'Error Subscription: '||p_event.getErrorSubscription());
129: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_msg',
130: 'Error Message: '||p_event.getErrorMessage());
131: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_stk',

Line 129: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_msg',

125: end if;
126:
127: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_sub',
128: 'Error Subscription: '||p_event.getErrorSubscription());
129: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_msg',
130: 'Error Message: '||p_event.getErrorMessage());
131: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_stk',
132: 'Error Stack: '||p_event.getErrorStack());
133:

Line 131: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_stk',

127: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_sub',
128: 'Error Subscription: '||p_event.getErrorSubscription());
129: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_msg',
130: 'Error Message: '||p_event.getErrorMessage());
131: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_stk',
132: 'Error Stack: '||p_event.getErrorStack());
133:
134: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_rule.log.end',
135: 'Completed wf_rule.log rule function');

Line 134: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_rule.log.end',

130: 'Error Message: '||p_event.getErrorMessage());
131: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.error_stk',
132: 'Error Stack: '||p_event.getErrorStack());
133:
134: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_rule.log.end',
135: 'Completed wf_rule.log rule function');
136:
137: return 'SUCCESS';
138: exception

Line 140: wf_log_pkg.string(wf_log_pkg.level_error, 'wf.plsql.wf_rule.log.end',

136:
137: return 'SUCCESS';
138: exception
139: when others then
140: wf_log_pkg.string(wf_log_pkg.level_error, 'wf.plsql.wf_rule.log.end',
141: 'Error in wf_rule.log rule function');
142: wf_core.context('Wf_Event', 'Log', p_event.getEventName(), p_subscription_guid);
143: wf_event.setErrorInfo(p_event, 'ERROR');
144: return 'ERROR';

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

232:
233: -- Workflow --
234: if (wftype is not null) then
235:
236: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
237: wf_log_pkg.string(wf_log_pkg.level_statement,
238: 'wf.plsql.WF_RULE.default_rule.event',
239: 'Calling wf_engine.event()');
240: end if;

Line 237: wf_log_pkg.string(wf_log_pkg.level_statement,

233: -- Workflow --
234: if (wftype is not null) then
235:
236: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
237: wf_log_pkg.string(wf_log_pkg.level_statement,
238: 'wf.plsql.WF_RULE.default_rule.event',
239: 'Calling wf_engine.event()');
240: end if;
241:

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

262: -- Route --
263: /** single consumer queues do not need a To Agent **/
264: -- if (to_guid is not null) then
265: if (out_guid is not null) then
266: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
267: wf_log_pkg.string(wf_log_pkg.level_statement,
268: 'wf.plsql.WF_RULE.default_rule.route',
269: 'Routing...');
270: end if;

Line 267: wf_log_pkg.string(wf_log_pkg.level_statement,

263: /** single consumer queues do not need a To Agent **/
264: -- if (to_guid is not null) then
265: if (out_guid is not null) then
266: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
267: wf_log_pkg.string(wf_log_pkg.level_statement,
268: 'wf.plsql.WF_RULE.default_rule.route',
269: 'Routing...');
270: end if;
271:

Line 284: if (wf_log_pkg.wf_debug_flag = TRUE) then

280: wf_event.send(p_event);
281: end if;
282:
283: -- Debug --
284: if (wf_log_pkg.wf_debug_flag = TRUE) then
285: begin
286: res := wf_rule.log(p_subscription_guid, p_event);
287: exception
288: when others then null;

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

345: where guid = p_subscription_guid;
346:
347: -- Workflow --
348: if (wftype is not null) then
349: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
350: wf_log_pkg.string(wf_log_pkg.level_procedure,
351: 'wf.plsql.WF_RULE.workflow_protocol.event',
352: 'Calling wf_engine.event()');
353: end if;

Line 350: wf_log_pkg.string(wf_log_pkg.level_procedure,

346:
347: -- Workflow --
348: if (wftype is not null) then
349: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
350: wf_log_pkg.string(wf_log_pkg.level_procedure,
351: 'wf.plsql.WF_RULE.workflow_protocol.event',
352: 'Calling wf_engine.event()');
353: end if;
354: --

Line 389: if (wf_log_pkg.wf_debug_flag = TRUE) then

385: event_message => p_event);
386: end if;
387:
388: -- Debug --
389: if (wf_log_pkg.wf_debug_flag = TRUE) then
390: res := wf_rule.log(p_subscription_guid, p_event);
391: end if;
392:
393: return 'SUCCESS';

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

419: where guid = p_subscription_guid;
420:
421: -- Workflow --
422: if (wftype is not null) then
423: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
424: wf_log_pkg.string(wf_log_pkg.level_procedure,
425: 'wf.plsql.WF_RULE.error_rule.event',
426: 'Calling wf_engine.event()');
427: end if;

Line 424: wf_log_pkg.string(wf_log_pkg.level_procedure,

420:
421: -- Workflow --
422: if (wftype is not null) then
423: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
424: wf_log_pkg.string(wf_log_pkg.level_procedure,
425: 'wf.plsql.WF_RULE.error_rule.event',
426: 'Calling wf_engine.event()');
427: end if;
428:

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

444: -- Route --
445: /** single consumer queues do not need a To Agent **/
446: -- if (to_guid is not null) then
447: if (out_guid is not null) then
448: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
449: wf_log_pkg.string(wf_log_pkg.level_statement,
450: 'wf.plsql.WF_RULE.error_rule.route',
451: 'Routing...');
452: end if;

Line 449: wf_log_pkg.string(wf_log_pkg.level_statement,

445: /** single consumer queues do not need a To Agent **/
446: -- if (to_guid is not null) then
447: if (out_guid is not null) then
448: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
449: wf_log_pkg.string(wf_log_pkg.level_statement,
450: 'wf.plsql.WF_RULE.error_rule.route',
451: 'Routing...');
452: end if;
453: p_event.From_Agent := wf_event.newAgent(out_guid);

Line 466: if (wf_log_pkg.wf_debug_flag = TRUE) then

462: end if;
463:
464:
465: -- Debug --
466: if (wf_log_pkg.wf_debug_flag = TRUE) then
467: begin
468: res := wf_rule.log(p_subscription_guid, p_event);
469: exception
470: when others then null;

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

517:
518: -- Initialize Start and End
519: l_start:= 1;
520: l_end := length(l_parameters);
521: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
522: wf_log_pkg.string(wf_log_pkg.level_statement,
523: 'wf.plsql.WF_RULE.setparametersintoparameterlist.params',
524: 'Length of Parameters is '||l_end);
525: end if;

Line 522: wf_log_pkg.string(wf_log_pkg.level_statement,

518: -- Initialize Start and End
519: l_start:= 1;
520: l_end := length(l_parameters);
521: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
522: wf_log_pkg.string(wf_log_pkg.level_statement,
523: 'wf.plsql.WF_RULE.setparametersintoparameterlist.params',
524: 'Length of Parameters is '||l_end);
525: end if;
526:

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

524: 'Length of Parameters is '||l_end);
525: end if;
526:
527: while l_start < l_end loop
528: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
529: wf_log_pkg.string(wf_log_pkg.level_statement,
530: 'wf.plsql.WF_RULE.setparametersintoparameterlist.st_pos',
531: 'Start Position is:'||l_start);
532: end if;

Line 529: wf_log_pkg.string(wf_log_pkg.level_statement,

525: end if;
526:
527: while l_start < l_end loop
528: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
529: wf_log_pkg.string(wf_log_pkg.level_statement,
530: 'wf.plsql.WF_RULE.setparametersintoparameterlist.st_pos',
531: 'Start Position is:'||l_start);
532: end if;
533: -- Get End of Name=Value pair

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

532: end if;
533: -- Get End of Name=Value pair
534: l_endposition := instr(l_parameters, ' ', l_start, 1);
535:
536: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
537: wf_log_pkg.string(wf_log_pkg.level_statement,
538: 'wf.plsql.WF_RULE.setparametersintoparameterlist.end_pos',
539: 'EndPosition of Name=Value Pair: '||l_endposition);
540: end if;

Line 537: wf_log_pkg.string(wf_log_pkg.level_statement,

533: -- Get End of Name=Value pair
534: l_endposition := instr(l_parameters, ' ', l_start, 1);
535:
536: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
537: wf_log_pkg.string(wf_log_pkg.level_statement,
538: 'wf.plsql.WF_RULE.setparametersintoparameterlist.end_pos',
539: 'EndPosition of Name=Value Pair: '||l_endposition);
540: end if;
541:

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

541:
542: -- Extract Name=Value Pair
543: l_namevalue := rtrim(ltrim(substr(l_parameters, l_start, l_endposition-l_start)));
544:
545: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
546: wf_log_pkg.string(wf_log_pkg.level_statement,
547: 'wf.plsql.WF_RULE.setparametersintoparameterlist.namevalue',
548: 'Name=Value Pair is:'||l_namevalue);
549: end if;

Line 546: wf_log_pkg.string(wf_log_pkg.level_statement,

542: -- Extract Name=Value Pair
543: l_namevalue := rtrim(ltrim(substr(l_parameters, l_start, l_endposition-l_start)));
544:
545: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
546: wf_log_pkg.string(wf_log_pkg.level_statement,
547: 'wf.plsql.WF_RULE.setparametersintoparameterlist.namevalue',
548: 'Name=Value Pair is:'||l_namevalue);
549: end if;
550:

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

550:
551: -- Extract Name part of Name=Value pair
552: l_equalpos := instr(l_namevalue, '=', 1, 1);
553: l_name := substr(l_namevalue,1,l_equalpos-1);
554: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
555: wf_log_pkg.string(wf_log_pkg.level_statement,
556: 'wf.plsql.WF_RULE.setparametersintoparameterlist.paramname',
557: 'Parameter Name='||l_name);
558: end if;

Line 555: wf_log_pkg.string(wf_log_pkg.level_statement,

551: -- Extract Name part of Name=Value pair
552: l_equalpos := instr(l_namevalue, '=', 1, 1);
553: l_name := substr(l_namevalue,1,l_equalpos-1);
554: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
555: wf_log_pkg.string(wf_log_pkg.level_statement,
556: 'wf.plsql.WF_RULE.setparametersintoparameterlist.paramname',
557: 'Parameter Name='||l_name);
558: end if;
559:

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

558: end if;
559:
560: -- Extract Value part of Name=Value pair
561: l_value := substr(l_namevalue,l_equalpos+1,length(l_namevalue));
562: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
563: wf_log_pkg.string(wf_log_pkg.level_statement,
564: 'wf.plsql.WF_RULE.setparametersintoparameterlist.paramvalue',
565: 'Parameter Value='||l_value);
566: end if;

Line 563: wf_log_pkg.string(wf_log_pkg.level_statement,

559:
560: -- Extract Value part of Name=Value pair
561: l_value := substr(l_namevalue,l_equalpos+1,length(l_namevalue));
562: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
563: wf_log_pkg.string(wf_log_pkg.level_statement,
564: 'wf.plsql.WF_RULE.setparametersintoparameterlist.paramvalue',
565: 'Parameter Value='||l_value);
566: end if;
567:

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

656: CONTEXT => l_context,
657: SEND_COMMENT => l_send_comment,
658: PRIORITY => l_priority);
659:
660: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
661: wf_log_pkg.string(wf_log_pkg.level_statement,
662: 'wf.plsql.WF_RULE.SendNotification.nid',
663: 'Nid:'||to_char(l_nid));
664: end if;

Line 661: wf_log_pkg.string(wf_log_pkg.level_statement,

657: SEND_COMMENT => l_send_comment,
658: PRIORITY => l_priority);
659:
660: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
661: wf_log_pkg.string(wf_log_pkg.level_statement,
662: 'wf.plsql.WF_RULE.SendNotification.nid',
663: 'Nid:'||to_char(l_nid));
664: end if;
665:

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

759:
760: -- Route --
761: /** single consumer queues do not need a To Agent **/
762: if (out_guid is not null) then
763: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
764: wf_log_pkg.string(wf_log_pkg.level_statement,
765: 'wf.plsql.WF_RULE.instance_default_rule.route',
766: 'Routing...');
767: end if;

Line 764: wf_log_pkg.string(wf_log_pkg.level_statement,

760: -- Route --
761: /** single consumer queues do not need a To Agent **/
762: if (out_guid is not null) then
763: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
764: wf_log_pkg.string(wf_log_pkg.level_statement,
765: 'wf.plsql.WF_RULE.instance_default_rule.route',
766: 'Routing...');
767: end if;
768: p_event.From_Agent := wf_event.newAgent(out_guid);

Line 777: if (wf_log_pkg.wf_debug_flag = TRUE) then

773: wf_event.send(p_event);
774: end if;
775:
776: -- Debug --
777: if (wf_log_pkg.wf_debug_flag = TRUE) then
778: begin
779: res := wf_rule.log(p_subscription_guid, p_event);
780: exception
781: when others then null;