DBA Data[Home] [Help]

APPS.ASP_SVCCONTRACT_ALERT_AGENT dependencies on WF_ENGINE

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

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

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

110: If(funcmode = 'RUN') Then
111: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,
112: itemkey =>itemkey,
113: aname =>'ALERT_SOURCE_OBJECT_CODE');
114: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
115: itemkey =>itemkey,
116: aname =>'ALERT_NAME');
117: l_contract_header_id := wf_engine.GetItemAttrText( itemtype =>itemtype,
118: itemkey =>itemkey,

Line 117: l_contract_header_id := wf_engine.GetItemAttrText( itemtype =>itemtype,

113: aname =>'ALERT_SOURCE_OBJECT_CODE');
114: l_alert_code := wf_engine.GetItemAttrText( itemtype =>itemtype,
115: itemkey =>itemkey,
116: aname =>'ALERT_NAME');
117: l_contract_header_id := wf_engine.GetItemAttrText( itemtype =>itemtype,
118: itemkey =>itemkey,
119: aname =>'ALERT_SOURCE_OBJECT_ID');
120:
121: BEGIN

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

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

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

190: end if;
191: end loop;
192: exception
193: When Others then
194: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');
195: end;
196:
197: if(l_sms_users_count > 0) then
198: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SMS_SUBS', 'YES');

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

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

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

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

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

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

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

207: end if;
208: end if;
209:
210: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);
211: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_USERS', l_email_users);
212: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_FND_USERS', l_sms_fnd_users);
213: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_FND_USERS', l_email_fnd_users);
214: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'YES');
215:

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

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

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

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

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

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

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

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