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

Line 93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

89: AND rownum < 2;
90:
91: BEGIN
92: l_api_name := 'Evaluate_Alerts';
93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
97:

Line 94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

90:
91: BEGIN
92: l_api_name := 'Evaluate_Alerts';
93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
97:
98: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;

Line 95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

91: BEGIN
92: l_api_name := 'Evaluate_Alerts';
93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
97:
98: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
99: l_sms_users_count := 0;

Line 96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

92: l_api_name := 'Evaluate_Alerts';
93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
97:
98: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
99: l_sms_users_count := 0;
100: l_email_users_count := 0;

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

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

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

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

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

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

Line 134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_delinquency_id '||l_delinquency_id);

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

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

131: if(l_debug_procedure >= l_debug_runtime) then
132: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
133: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_delinquency_id '||l_delinquency_id);
135: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
136: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
137: end if;
138:
139:

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

132: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
133: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_delinquency_id '||l_delinquency_id);
135: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
136: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
137: end if;
138:
139:
140: If l_event_entity = 'INVOICE' Then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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