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_ORDER_ALERT_AGENT dependencies on FND_LOG

Line 89: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

85: and rownum < 2;
86:
87: BEGIN
88: l_api_name := 'Evaluate_Alerts';
89: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
90: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
91: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
92: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
93:

Line 90: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

86:
87: BEGIN
88: l_api_name := 'Evaluate_Alerts';
89: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
90: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
91: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
92: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
93:
94: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;

Line 91: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

87: BEGIN
88: l_api_name := 'Evaluate_Alerts';
89: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
90: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
91: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
92: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
93:
94: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
95: l_sms_users_count := 0;

Line 92: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

88: l_api_name := 'Evaluate_Alerts';
89: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
90: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
91: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
92: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
93:
94: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
95: l_sms_users_count := 0;
96: l_email_users_count := 0;

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

95: l_sms_users_count := 0;
96: l_email_users_count := 0;
97:
98: if(l_debug_procedure >= l_debug_runtime) then
99: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
100: end if;
101:
102: If(funcmode = 'RUN') Then
103: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,

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

125: END;
126:
127:
128: if(l_debug_procedure >= l_debug_runtime) then
129: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
130: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);
132: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
133:

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

126:
127:
128: if(l_debug_procedure >= l_debug_runtime) then
129: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
130: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);
132: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
133:
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');

Line 131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);

127:
128: if(l_debug_procedure >= l_debug_runtime) then
129: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
130: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);
132: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
133:
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
135: end if;

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

128: if(l_debug_procedure >= l_debug_runtime) then
129: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
130: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);
132: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
133:
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
135: end if;
136:

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

130: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);
132: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
133:
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
135: end if;
136:
137:
138: If l_event_entity = 'ORDER' Then

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

146: x_msg_count => l_msg_count,
147: x_msg_data => l_msg_data
148: );
149: if(l_debug_procedure >= l_debug_runtime) then
150: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_return_status '||l_return_status);
151: end if;
152:
153: IF l_return_status <> 'S' THEN
154: --Set debug messages

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

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

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

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

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

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

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

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

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

208:
209: if(l_debug_procedure >= l_debug_runtime) then
210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_sms_users_count '||l_sms_users_count);
211: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_email_users_count '||l_email_users_count);
212: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
213: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
214: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
215: end if;
216:

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

209: if(l_debug_procedure >= l_debug_runtime) then
210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_sms_users_count '||l_sms_users_count);
211: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_email_users_count '||l_email_users_count);
212: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
213: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
214: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
215: end if;
216:
217: ELSE

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

210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_sms_users_count '||l_sms_users_count);
211: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_email_users_count '||l_email_users_count);
212: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_USERS '||l_sms_users);
213: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_USERS '||l_email_users);
214: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'FOUND_SUBS '||'YES');
215: end if;
216:
217: ELSE
218: wf_engine.SetItemAttrText(itemtype, itemkey, 'FOUND_SUBS', 'NO');