eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASP_SERVICE_ALERT_AGENT dependencies on FND_LOG

Line 83: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

79: and rownum < 2;
80:
81: BEGIN
82: l_api_name := 'Evaluate_Alerts';
83: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
84: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
85: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
86: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
87:

Line 84: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

80:
81: BEGIN
82: l_api_name := 'Evaluate_Alerts';
83: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
84: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
85: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
86: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
87:
88: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;

Line 85: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

81: BEGIN
82: l_api_name := 'Evaluate_Alerts';
83: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
84: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
85: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
86: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
87:
88: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
89: l_sms_users_count := 0;

Line 86: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

82: l_api_name := 'Evaluate_Alerts';
83: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
84: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
85: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
86: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
87:
88: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
89: l_sms_users_count := 0;
90: l_email_users_count := 0;

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

89: l_sms_users_count := 0;
90: l_email_users_count := 0;
91:
92: if(l_debug_procedure >= l_debug_runtime) then
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,

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

119: END;
120:
121:
122: if(l_debug_procedure >= l_debug_runtime) then
123: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
124: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
126: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');

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

120:
121:
122: if(l_debug_procedure >= l_debug_runtime) then
123: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
124: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
126: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
128: end if;

Line 125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);

121:
122: if(l_debug_procedure >= l_debug_runtime) then
123: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
124: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
126: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
128: end if;
129:

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

122: if(l_debug_procedure >= l_debug_runtime) then
123: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
124: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
126: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
128: end if;
129:
130: If l_event_entity = 'SERVICE_REQUEST' Then

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

123: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
124: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
126: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
128: end if;
129:
130: If l_event_entity = 'SERVICE_REQUEST' Then
131: ASP_ALERTS_PUB.Get_Matching_Subscriptions(

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

139: x_msg_data => l_msg_data
140: );
141:
142: if(l_debug_procedure >= l_debug_runtime) then
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');

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

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;
189: if(l_email_users_count > 0) then
190: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_EMAIL_SUBS', 'YES');

Line 192: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_EMAIL_SUBS '||'YES');

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;
195:
196: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_USERS', l_sms_users);

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

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);
205: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
206: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
207: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');

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

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);
205: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
206: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
207: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
208: end if;

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

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);
205: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
206: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
207: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
208: end if;
209:

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

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);
205: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
206: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
207: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
208: end if;
209:
210: ELSE

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

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);
205: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
206: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
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');