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 WF_ENGINE

Line 104: save_threshold := wf_engine.threshold;

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;
106: l_REQUEST_ID := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
107: l_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
108: l_PROGRAM_ID := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));

Line 179: wf_engine.threshold := -1;

175: end if;
176:
177: for del_rec in getDelinquencyDeltaRun
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;

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 191: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);

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

Line 192: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'INVOICE_OVERDUE_ALERT');

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

Line 193: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'INVOICE');

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

Line 194: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_delinquency_id);

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

Line 195: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);

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

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 206: wf_engine.threshold := save_threshold;

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
208: set program_ref_date = l_current_run_ref_date
209: where program_object_code = 'ASPODINV' --'INVOICE'
210: and status_code = 'S';

Line 217: wf_engine.threshold := save_threshold;

213:
214:
215: EXCEPTION
216: WHEN others THEN
217: wf_engine.threshold := save_threshold;
218: raise;
219:
220: END Alert_Overdue_Invoice;
221: