DBA Data[Home] [Help]

APPS.ASP_ORDER_ALERT_AGENT dependencies on WF_ENGINE

Line 103: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,

99: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
100: end if;
101:
102: If(funcmode = 'RUN') Then
103: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,
104: itemkey =>itemkey,
105: aname =>'ALERT_SOURCE_OBJECT_CODE');
106: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
107: itemkey =>itemkey,

Line 106: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,

102: If(funcmode = 'RUN') Then
103: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,
104: itemkey =>itemkey,
105: aname =>'ALERT_SOURCE_OBJECT_CODE');
106: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
107: itemkey =>itemkey,
108: aname =>'ALERT_NAME');
109: l_blanket_header_id := wf_engine.GetItemAttrText( itemtype =>itemtype,
110: itemkey =>itemkey,

Line 109: l_blanket_header_id := wf_engine.GetItemAttrText( itemtype =>itemtype,

105: aname =>'ALERT_SOURCE_OBJECT_CODE');
106: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
107: itemkey =>itemkey,
108: aname =>'ALERT_NAME');
109: l_blanket_header_id := wf_engine.GetItemAttrText( itemtype =>itemtype,
110: itemkey =>itemkey,
111: aname =>'ALERT_SOURCE_OBJECT_ID');
112:
113: BEGIN

Line 155: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');

151: end if;
152:
153: IF l_return_status <> 'S' THEN
154: --Set debug messages
155: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');
156: resultout := 'COMPLETE:SUCCESS';
157: return;
158: END IF;
159:

Line 188: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');

184: end if;
185: end loop;
186: exception
187: When Others then
188: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');
189: end;
190: if(l_sms_users_count > 0) then
191: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SMS_SUBS', 'YES');
192: if(l_debug_procedure >= l_debug_runtime) then

Line 191: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SMS_SUBS', 'YES');

187: When Others then
188: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');
189: end;
190: if(l_sms_users_count > 0) then
191: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SMS_SUBS', 'YES');
192: if(l_debug_procedure >= l_debug_runtime) then
193: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SMS_SUBS '||'YES');
194: end if;
195: end if;

Line 197: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_EMAIL_SUBS', 'YES');

193: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SMS_SUBS '||'YES');
194: end if;
195: end if;
196: if(l_email_users_count > 0) then
197: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_EMAIL_SUBS', 'YES');
198: if(l_debug_procedure >= l_debug_runtime) then
199: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_EMAIL_SUBS '||'YES');
200: end if;
201: end if;

Line 203: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);

199: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_EMAIL_SUBS '||'YES');
200: end if;
201: end if;
202:
203: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
204: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
205: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
206: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
207: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');

Line 204: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);

200: end if;
201: end if;
202:
203: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
204: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
205: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
206: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
207: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');
208:

Line 205: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);

201: end if;
202:
203: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
204: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
205: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
206: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
207: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');
208:
209: if(l_debug_procedure >= l_debug_runtime) then

Line 206: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);

202:
203: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
204: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
205: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
206: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
207: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');
208:
209: if(l_debug_procedure >= l_debug_runtime) then
210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_sms_users_count '||l_sms_users_count);

Line 207: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');

203: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
204: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
205: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
206: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
207: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');
208:
209: if(l_debug_procedure >= l_debug_runtime) then
210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_sms_users_count '||l_sms_users_count);
211: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_email_users_count '||l_email_users_count);

Line 218: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');

214: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
215: end if;
216:
217: ELSE
218: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');
219: END IF;--l_subscriber_list.count > 0
220:
221: resultout := 'COMPLETE:SUCCESS';
222: return;