DBA Data[Home] [Help]

APPS.ASP_INVOICE_ALERT_AGENT dependencies on WF_ENGINE

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

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

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

106: If(funcmode = 'RUN') Then
107: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,
108: itemkey =>itemkey,
109: aname =>'ALERT_SOURCE_OBJECT_CODE');
110: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
111: itemkey =>itemkey,
112: aname =>'ALERT_NAME');
113: l_delinquency_id := wf_engine.GetItemAttrText( itemtype =>itemtype,
114: itemkey =>itemkey,

Line 113: l_delinquency_id := wf_engine.GetItemAttrText( itemtype =>itemtype,

109: aname =>'ALERT_SOURCE_OBJECT_CODE');
110: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
111: itemkey =>itemkey,
112: aname =>'ALERT_NAME');
113: l_delinquency_id := wf_engine.GetItemAttrText( itemtype =>itemtype,
114: itemkey =>itemkey,
115: aname =>'ALERT_SOURCE_OBJECT_ID');
116:
117: BEGIN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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