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_RULE

Line 1: package body WF_RULE as

1: package body WF_RULE as
2: /* $Header: wfruleb.pls 120.5 2006/02/17 03:25:51 smayze ship $ */
3: --------------------------------------------------------------------------
4: /*
5: ** get_sub_parameters (PRIVATE) - retrieve the value of the PARAMETERS

Line 20: wf_core.context('Wf_Rule', 'get_sub_parameters', p_subscription_guid);

16:
17: return parm;
18: exception
19: when no_data_found then
20: wf_core.context('Wf_Rule', 'get_sub_parameters', p_subscription_guid);
21: wf_core.raise('WFE_SUBSC_NOTEXIST');
22: end;
23: --------------------------------------------------------------------------
24: /*

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 44: 'Begin wf_rule.log rule function');

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',
48: 'Event is null. Returning.');

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 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 111: 'wf.plsql.wf_rule.log.event_data', 'Begin EventData');

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;
115: clob_len := dbms_lob.getlength(myclob);

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 135: 'Completed wf_rule.log rule function');

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
139: when others then

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 141: 'Error in wf_rule.log rule function');

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';
145: end;

Line 156: l_parameters := upper(wf_rule.get_sub_parameters(p_subscription_guid));

152: is
153: msg varchar2(4000);
154: l_parameters varchar2(4000);
155: begin
156: l_parameters := upper(wf_rule.get_sub_parameters(p_subscription_guid));
157: msg := WF_EVENT_FUNCTIONS_PKG.SUBSCRIPTIONPARAMETERS(l_parameters, 'ERROR_MESSAGE');
158: wf_event.setErrorInfo(p_event, 'ERROR');
159: p_event.setErrorMessage(wf_core.substitute('WFERR', msg));
160:

Line 173: l_parameters := upper(wf_rule.get_sub_parameters(p_subscription_guid));

169: is
170: msg varchar2(4000);
171: l_parameters varchar2(4000);
172: begin
173: l_parameters := upper(wf_rule.get_sub_parameters(p_subscription_guid));
174: msg := WF_EVENT_FUNCTIONS_PKG.SUBSCRIPTIONPARAMETERS(l_parameters, 'ERROR_MESSAGE');
175: wf_event.setErrorInfo(p_event, 'WARNING');
176: p_event.setErrorMessage(wf_core.substitute('WFERR', msg));
177:

Line 238: 'wf.plsql.WF_RULE.default_rule.event',

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:
242: lparamlist := p_event.Parameter_List;

Line 268: 'wf.plsql.WF_RULE.default_rule.route',

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:
272: p_event.From_Agent := wf_event.newAgent(out_guid);

Line 286: res := wf_rule.log(p_subscription_guid, p_event);

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;
289: end;
290: end if;

Line 300: wf_core.context('Wf_Rule', 'Default_Rule', p_event.getEventName(),

296: --Raise this exception to caller
297: raise;
298:
299: when others then
300: wf_core.context('Wf_Rule', 'Default_Rule', p_event.getEventName(),
301: p_subscription_guid);
302: wf_event.setErrorInfo(p_event, 'ERROR');
303: return 'ERROR';
304: end;

Line 351: 'wf.plsql.WF_RULE.workflow_protocol.event',

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: --
355: -- Add Parameters to List

Line 390: res := wf_rule.log(p_subscription_guid, 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';
394: exception

Line 396: wf_core.context('Wf_Rule', 'Workflow_Protocol', p_event.getEventName(),

392:
393: return 'SUCCESS';
394: exception
395: when others then
396: wf_core.context('Wf_Rule', 'Workflow_Protocol', p_event.getEventName(),
397: p_subscription_guid);
398: wf_event.setErrorInfo(p_event, 'ERROR');
399: return 'ERROR';
400: end;

Line 425: 'wf.plsql.WF_RULE.error_rule.event',

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:
429: p_event.addParameterToList('SUB_GUID', p_subscription_guid);

Line 450: 'wf.plsql.WF_RULE.error_rule.route',

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);
454: p_event.To_Agent := wf_event.newAgent(to_guid);

Line 468: res := wf_rule.log(p_subscription_guid, p_event);

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;
471: end;
472: end if;

Line 477: wf_core.context('Wf_Rule', 'Error_Rule', p_event.getEventName(),

473:
474: return 'SUCCESS';
475: exception
476: when others then
477: wf_core.context('Wf_Rule', 'Error_Rule', p_event.getEventName(),
478: p_subscription_guid);
479: raise;
480: end;
481: ----------------------------------------------------------------------------

Line 523: 'wf.plsql.WF_RULE.setparametersintoparameterlist.params',

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:
527: while l_start < l_end loop

Line 530: 'wf.plsql.WF_RULE.setparametersintoparameterlist.st_pos',

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
534: l_endposition := instr(l_parameters, ' ', l_start, 1);

Line 538: 'wf.plsql.WF_RULE.setparametersintoparameterlist.end_pos',

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:
542: -- Extract Name=Value Pair

Line 547: 'wf.plsql.WF_RULE.setparametersintoparameterlist.namevalue',

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:
551: -- Extract Name part of Name=Value pair

Line 556: 'wf.plsql.WF_RULE.setparametersintoparameterlist.paramname',

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:
560: -- Extract Value part of Name=Value pair

Line 564: 'wf.plsql.WF_RULE.setparametersintoparameterlist.paramvalue',

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:
568: -- OK, Set the Value into the Parameter List

Line 587: wf_core.context('Wf_Rule', 'SetParametersIntoParameterList',

583:
584: return 'SUCCESS';
585: exception
586: when others then
587: wf_core.context('Wf_Rule', 'SetParametersIntoParameterList',
588: p_event.getEventName(),p_subscription_guid);
589: wf_event.setErrorInfo(p_event, 'ERROR');
590: return 'ERROR';
591: end;

Line 662: 'wf.plsql.WF_RULE.SendNotification.nid',

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:
666: --Get the Text Notification Attributes

Line 756: 'wf.plsql.WF_RULE.instance_default_rule.route',

752: /** single consumer queues do not need a To Agent **/
753: if (out_guid is not null) then
754: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
755: wf_log_pkg.string(wf_log_pkg.level_statement,
756: 'wf.plsql.WF_RULE.instance_default_rule.route',
757: 'Routing...');
758: end if;
759: p_event.From_Agent := wf_event.newAgent(out_guid);
760: p_event.To_Agent := wf_event.newAgent(to_guid);

Line 770: res := wf_rule.log(p_subscription_guid, p_event);

766:
767: -- Debug --
768: if (wf_log_pkg.wf_debug_flag = TRUE) then
769: begin
770: res := wf_rule.log(p_subscription_guid, p_event);
771: exception
772: when others then null;
773: end;
774: end if;

Line 782: wf_core.context('Wf_Rule', 'Instance_Default_Rule', p_event.getEventName(),

778: when resource_busy then
779: --Raise the error to the caller to handle it
780: raise;
781: when others then
782: wf_core.context('Wf_Rule', 'Instance_Default_Rule', p_event.getEventName(),
783: p_subscription_guid);
784: wf_event.setErrorInfo(p_event, 'ERROR');
785: return 'ERROR';
786: end;

Line 878: wf_core.context('WF_RULE', 'Default_Generate', p_event_name, p_event_key);

874: return doc;
875:
876: exception
877: when others then
878: wf_core.context('WF_RULE', 'Default_Generate', p_event_name, p_event_key);
879: raise;
880: end Default_Generate;
881:
882:

Line 884: end WF_RULE;

880: end Default_Generate;
881:
882:
883:
884: end WF_RULE;