93:
94:
95: BEGIN
96: l_api_name := 'Evaluate_Alerts';
97: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
98: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
99: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
100: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
101:
94:
95: BEGIN
96: l_api_name := 'Evaluate_Alerts';
97: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
98: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
99: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
100: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
101:
102: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
95: BEGIN
96: l_api_name := 'Evaluate_Alerts';
97: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
98: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
99: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
100: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
101:
102: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
103: l_sms_users_count := 0;
96: l_api_name := 'Evaluate_Alerts';
97: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
98: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
99: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
100: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
101:
102: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
103: l_sms_users_count := 0;
104: l_email_users_count := 0;
103: l_sms_users_count := 0;
104: l_email_users_count := 0;
105:
106: if(l_debug_procedure >= l_debug_runtime) then
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,
133: END;
134:
135:
136: if(l_debug_procedure >= l_debug_runtime) then
137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
138: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
139: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);
140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
141: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
134:
135:
136: if(l_debug_procedure >= l_debug_runtime) then
137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
138: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
139: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);
140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
141: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
142: end if;
135:
136: if(l_debug_procedure >= l_debug_runtime) then
137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
138: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
139: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);
140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
141: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
142: end if;
143:
136: if(l_debug_procedure >= l_debug_runtime) then
137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
138: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
139: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);
140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
141: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
142: end if;
143:
144: If l_event_entity = 'SERVICE_CONTRACT' Then
137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
138: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
139: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);
140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
141: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
142: end if;
143:
144: If l_event_entity = 'SERVICE_CONTRACT' Then
145: ASP_ALERTS_PUB.Get_Matching_Subscriptions(
152: x_msg_count => l_msg_count,
153: x_msg_data => l_msg_data
154: );
155: if(l_debug_procedure >= l_debug_runtime) then
156: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_return_status '||l_return_status);
157: end if;
158:
159: IF l_return_status <> 'S' THEN
160: --Set debug messages
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;
203: if(l_email_users_count > 0) then
204: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_EMAIL_SUBS', 'YES');
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;
209:
210: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_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);
219: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
220: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
221: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
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);
219: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
220: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
221: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
222: end if;
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);
219: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
220: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
221: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
222: end if;
223:
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);
219: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
220: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
221: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
222: end if;
223:
224: ELSE
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);
219: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
220: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
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');