DBA Data[Home] [Help]

APPS.ASP_SVCCONTRACT_ALERT_AGENT dependencies on FND_LOG

Line 97: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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:

Line 98: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

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;

Line 99: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

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;

Line 100: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

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;

Line 107: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);

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,

Line 137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);

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');

Line 138: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);

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;

Line 139: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);

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:

Line 140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);

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

Line 141: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');

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(

Line 156: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_return_status '||l_return_status);

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

Line 200: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SMS_SUBS '||'YES');

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');

Line 206: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, '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);

Line 217: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_sms_users_count '||l_sms_users_count);

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');

Line 218: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_email_users_count '||l_email_users_count);

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;

Line 219: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);

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:

Line 220: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);

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

Line 221: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');

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');