DBA Data[Home] [Help]

APPS.ASP_SERVICE_ALERT_AGENT dependencies on WF_ENGINE

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

93: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
94: end if;
95:
96: If(funcmode = 'RUN') Then
97: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,
98: itemkey =>itemkey,
99: aname =>'ALERT_SOURCE_OBJECT_CODE');
100: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
101: itemkey =>itemkey,

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

96: If(funcmode = 'RUN') Then
97: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,
98: itemkey =>itemkey,
99: aname =>'ALERT_SOURCE_OBJECT_CODE');
100: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
101: itemkey =>itemkey,
102: aname =>'ALERT_NAME');
103: l_incident_id := wf_engine.GetItemAttrText( itemtype =>itemtype,
104: itemkey =>itemkey,

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

99: aname =>'ALERT_SOURCE_OBJECT_CODE');
100: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
101: itemkey =>itemkey,
102: aname =>'ALERT_NAME');
103: l_incident_id := wf_engine.GetItemAttrText( itemtype =>itemtype,
104: itemkey =>itemkey,
105: aname =>'ALERT_SOURCE_OBJECT_ID');
106:
107: BEGIN

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

143: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_return_status '||l_return_status);
144: end if;
145: IF l_return_status <> 'S' THEN
146: --Set debug messages
147: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');
148: resultout := 'COMPLETE:SUCCESS';
149: return;
150: END IF;
151:

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

176: end if;
177: end loop;
178: Exception
179: When Others then
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');
181: END;
182:
183: if(l_sms_users_count > 0) then
184: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SMS_SUBS', 'YES');

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

180: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');
181: END;
182:
183: if(l_sms_users_count > 0) then
184: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SMS_SUBS', 'YES');
185: if(l_debug_procedure >= l_debug_runtime) then
186: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SMS_SUBS '||'YES');
187: end if;
188: end if;

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

186: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SMS_SUBS '||'YES');
187: end if;
188: end if;
189: if(l_email_users_count > 0) then
190: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_EMAIL_SUBS', 'YES');
191: if(l_debug_procedure >= l_debug_runtime) then
192: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_EMAIL_SUBS '||'YES');
193: end if;
194: end if;

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

192: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_EMAIL_SUBS '||'YES');
193: end if;
194: end if;
195:
196: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
197: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
198: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
199: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
200: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');

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

193: end if;
194: end if;
195:
196: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
197: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
198: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
199: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
200: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');
201:

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

194: end if;
195:
196: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
197: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
198: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
199: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
200: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');
201:
202: if(l_debug_procedure >= l_debug_runtime) then

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

195:
196: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
197: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
198: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
199: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
200: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');
201:
202: if(l_debug_procedure >= l_debug_runtime) then
203: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_sms_users_count '||l_sms_users_count);

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

196: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
197: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
198: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
199: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
200: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');
201:
202: if(l_debug_procedure >= l_debug_runtime) then
203: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_sms_users_count '||l_sms_users_count);
204: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_email_users_count '||l_email_users_count);

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

207: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
208: end if;
209:
210: ELSE
211: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');
212: END IF;--l_subscriber_list.count > 0
213:
214: resultout := 'COMPLETE:SUCCESS';
215: return;