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

Line 96: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

92:
93:
94: BEGIN
95: l_api_name := 'Alert_Overdue_Invoice';
96: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
98: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
99: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
100: if(l_debug_procedure >= l_debug_runtime) then

Line 97: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

93:
94: BEGIN
95: l_api_name := 'Alert_Overdue_Invoice';
96: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
98: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
99: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
100: if(l_debug_procedure >= l_debug_runtime) then
101: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);

Line 98: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

94: BEGIN
95: l_api_name := 'Alert_Overdue_Invoice';
96: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
98: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
99: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
100: if(l_debug_procedure >= l_debug_runtime) then
101: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
102: end if;

Line 99: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

95: l_api_name := 'Alert_Overdue_Invoice';
96: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
98: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
99: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
100: if(l_debug_procedure >= l_debug_runtime) then
101: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
102: end if;
103:

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

97: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
98: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
99: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
100: if(l_debug_procedure >= l_debug_runtime) then
101: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
102: end if;
103:
104: save_threshold := wf_engine.threshold;
105: l_PROGRAM_START_DATE := sysdate;

Line 118: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After opening cursor getLastRunDate');

114: open getLastRunDate;
115: fetch getLastRunDate into l_program_ref_date;
116: close getLastRunDate;
117: if(l_debug_procedure >= l_debug_runtime) then
118: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After opening cursor getLastRunDate');
119: end if;
120:
121: l_current_run_ref_date := sysdate;
122:

Line 125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is null');

121: l_current_run_ref_date := sysdate;
122:
123: IF(l_program_ref_date is null) THEN
124: if(l_debug_procedure >= l_debug_runtime) then
125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is null');
126: end if;
127: delete asp_program_run_dates where PROGRAM_OBJECT_CODE = 'ASPODINV';
128: insert into asp_program_run_dates(
129: PROGRAM_RUN_ID,

Line 171: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is not null');

167:
168: commit;
169: ELSE
170: if(l_debug_procedure >= l_debug_runtime) then
171: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is not null');
172: end if;
173: if(l_debug_procedure >= l_debug_runtime) then
174: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before opening getDelinquencyDeltaRun');
175: end if;

Line 174: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before opening getDelinquencyDeltaRun');

170: if(l_debug_procedure >= l_debug_runtime) then
171: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is not null');
172: end if;
173: if(l_debug_procedure >= l_debug_runtime) then
174: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before opening getDelinquencyDeltaRun');
175: end if;
176:
177: for del_rec in getDelinquencyDeltaRun
178: loop

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

178: loop
179: wf_engine.threshold := -1;
180: l_delinquency_id := del_rec.delinquency_id;
181: if(l_debug_procedure >= l_debug_runtime) then
182: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_delinquency_id '||l_delinquency_id);
183: end if;
184:
185: SELECT l_delinquency_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
186: if(l_debug_procedure >= l_debug_runtime) then

Line 187: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);

183: end if;
184:
185: SELECT l_delinquency_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
186: if(l_debug_procedure >= l_debug_runtime) then
187: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
188: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.CreateProcess ASP_ALERT_PROCESS');
189: end if;
190: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
191: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);

Line 188: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.CreateProcess ASP_ALERT_PROCESS');

184:
185: SELECT l_delinquency_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
186: if(l_debug_procedure >= l_debug_runtime) then
187: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
188: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.CreateProcess ASP_ALERT_PROCESS');
189: end if;
190: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
191: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
192: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'INVOICE_OVERDUE_ALERT');

Line 197: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);

193: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'INVOICE');
194: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_delinquency_id);
195: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
196: if(l_debug_procedure >= l_debug_runtime) then
197: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
198: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.CreateProcess ASP_ALERT_PROCESS');
199: end if;
200: commit;
201: end loop;

Line 198: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.CreateProcess ASP_ALERT_PROCESS');

194: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_delinquency_id);
195: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
196: if(l_debug_procedure >= l_debug_runtime) then
197: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
198: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.CreateProcess ASP_ALERT_PROCESS');
199: end if;
200: commit;
201: end loop;
202: if(l_debug_procedure >= l_debug_runtime) then

Line 203: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After opening getDelinquencyDeltaRun');

199: end if;
200: commit;
201: end loop;
202: if(l_debug_procedure >= l_debug_runtime) then
203: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After opening getDelinquencyDeltaRun');
204: end if;
205:
206: wf_engine.threshold := save_threshold;
207: update asp_program_run_dates