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

Line 119: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

115:
116:
117: BEGIN
118: l_api_name := 'Alert_Expiring_SvcContracts';
119: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
120: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
121: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
122: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
123:

Line 120: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

116:
117: BEGIN
118: l_api_name := 'Alert_Expiring_SvcContracts';
119: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
120: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
121: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
122: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
123:
124: p_number_of_days := p_num_days;

Line 121: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

117: BEGIN
118: l_api_name := 'Alert_Expiring_SvcContracts';
119: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
120: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
121: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
122: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
123:
124: p_number_of_days := p_num_days;
125: if(l_debug_procedure >= l_debug_runtime) then

Line 122: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

118: l_api_name := 'Alert_Expiring_SvcContracts';
119: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
120: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
121: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
122: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
123:
124: p_number_of_days := p_num_days;
125: if(l_debug_procedure >= l_debug_runtime) then
126: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);

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

122: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
123:
124: p_number_of_days := p_num_days;
125: if(l_debug_procedure >= l_debug_runtime) then
126: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'user entered num of days '||to_char(p_number_of_days));
128: end if;
129: --if 1=1 then return; end if;
130: if (p_number_of_days is null) then

Line 127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'user entered num of days '||to_char(p_number_of_days));

123:
124: p_number_of_days := p_num_days;
125: if(l_debug_procedure >= l_debug_runtime) then
126: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'user entered num of days '||to_char(p_number_of_days));
128: end if;
129: --if 1=1 then return; end if;
130: if (p_number_of_days is null) then
131: p_number_of_days := 10;

Line 133: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'system assigned num of days '||to_char(p_number_of_days));

129: --if 1=1 then return; end if;
130: if (p_number_of_days is null) then
131: p_number_of_days := 10;
132: if(l_debug_procedure >= l_debug_runtime) then
133: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'system assigned num of days '||to_char(p_number_of_days));
134: end if;
135: end if;
136:
137: save_threshold := wf_engine.threshold;

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

147: open getLastRunDate;
148: fetch getLastRunDate into l_program_ref_date;
149: close getLastRunDate;
150: if(l_debug_procedure >= l_debug_runtime) then
151: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After opening cursor getLastRunDate');
152: end if;
153:
154: l_current_run_ref_date := sysdate;
155:

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

154: l_current_run_ref_date := sysdate;
155:
156: IF(l_program_ref_date is null) THEN
157: if(l_debug_procedure >= l_debug_runtime) then
158: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is null');
159: end if;
160: mo_global.set_policy_context('A',null);--authoring_ord_id
161: if(l_debug_procedure >= l_debug_runtime) then
162: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before opening getServiceContractsFreshRun');

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

158: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is null');
159: end if;
160: mo_global.set_policy_context('A',null);--authoring_ord_id
161: if(l_debug_procedure >= l_debug_runtime) then
162: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before opening getServiceContractsFreshRun');
163: end if;
164:
165: for svccontract_rec in getServiceContractsFreshRun
166: loop

Line 169: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_id '||l_contract_id);

165: for svccontract_rec in getServiceContractsFreshRun
166: loop
167: l_contract_id := svccontract_rec.contract_id;
168: if(l_debug_procedure >= l_debug_runtime) then
169: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_id '||l_contract_id);
170: end if;
171:
172: oks_renew_util_pub.GET_RENEWAL_TYPE(
173: p_api_version => 1.0,

Line 184: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After Calling oks_renew_util_pub.GET_RENEWAL_TYPE - x_return_status:'||l_return_status);

180: x_approval_type => l_approval_type,
181: x_threshold_used => l_threshold_used
182: );
183: if(l_debug_procedure >= l_debug_runtime) then
184: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After Calling oks_renew_util_pub.GET_RENEWAL_TYPE - x_return_status:'||l_return_status);
185: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_renewal_type '||l_renewal_type);
186: end if;
187:
188: if(nvl(l_renewal_type,'X') <> 'EVN') then

Line 185: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_renewal_type '||l_renewal_type);

181: x_threshold_used => l_threshold_used
182: );
183: if(l_debug_procedure >= l_debug_runtime) then
184: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After Calling oks_renew_util_pub.GET_RENEWAL_TYPE - x_return_status:'||l_return_status);
185: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_renewal_type '||l_renewal_type);
186: end if;
187:
188: if(nvl(l_renewal_type,'X') <> 'EVN') then
189: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;

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

187:
188: if(nvl(l_renewal_type,'X') <> 'EVN') then
189: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
190: if(l_debug_procedure >= l_debug_runtime) then
191: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
192: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.CreateProcess ASP_ALERT_PROCESS');
193: end if;
194: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
195: wf_engine.threshold := -1;

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

188: if(nvl(l_renewal_type,'X') <> 'EVN') then
189: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
190: if(l_debug_procedure >= l_debug_runtime) then
191: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
192: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.CreateProcess ASP_ALERT_PROCESS');
193: end if;
194: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
195: wf_engine.threshold := -1;
196: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);

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

198: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'SERVICE_CONTRACT');
199: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_contract_id);
200: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
201: if(l_debug_procedure >= l_debug_runtime) then
202: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
203: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.CreateProcess ASP_ALERT_PROCESS');
204: end if;
205: commit;
206: end if;

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

199: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_contract_id);
200: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
201: if(l_debug_procedure >= l_debug_runtime) then
202: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
203: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.CreateProcess ASP_ALERT_PROCESS');
204: end if;
205: commit;
206: end if;
207: end loop;

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

205: commit;
206: end if;
207: end loop;
208: if(l_debug_procedure >= l_debug_runtime) then
209: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After opening getServiceContractsFreshRun');
210: end if;
211:
212: --program_ref_date = current_run_ref_date of this run + X of this run
213: delete asp_program_run_dates where PROGRAM_OBJECT_CODE = 'ASPEXPSC';

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

253:
254: commit;
255: ELSE
256: if(l_debug_procedure >= l_debug_runtime) then
257: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is not null');
258: end if;
259: mo_global.set_policy_context('A',null);--authoring_ord_id
260: if(l_debug_procedure >= l_debug_runtime) then
261: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before opening getServiceContractsDeltaRun');

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

257: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is not null');
258: end if;
259: mo_global.set_policy_context('A',null);--authoring_ord_id
260: if(l_debug_procedure >= l_debug_runtime) then
261: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before opening getServiceContractsDeltaRun');
262: end if;
263:
264: for svccontract_rec in getServiceContractsDeltaRun
265: loop

Line 268: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_id '||l_contract_id);

264: for svccontract_rec in getServiceContractsDeltaRun
265: loop
266: l_contract_id := svccontract_rec.contract_id;
267: if(l_debug_procedure >= l_debug_runtime) then
268: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_id '||l_contract_id);
269: end if;
270:
271: oks_renew_util_pub.GET_RENEWAL_TYPE(
272: p_api_version => 1.0,

Line 283: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After Calling oks_renew_util_pub.GET_RENEWAL_TYPE - x_return_status:'||l_return_status);

279: x_approval_type => l_approval_type,
280: x_threshold_used => l_threshold_used
281: );
282: if(l_debug_procedure >= l_debug_runtime) then
283: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After Calling oks_renew_util_pub.GET_RENEWAL_TYPE - x_return_status:'||l_return_status);
284: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_renewal_type '||l_renewal_type);
285: end if;
286:
287: if(nvl(l_renewal_type,'X') <> 'EVN') then

Line 284: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_renewal_type '||l_renewal_type);

280: x_threshold_used => l_threshold_used
281: );
282: if(l_debug_procedure >= l_debug_runtime) then
283: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After Calling oks_renew_util_pub.GET_RENEWAL_TYPE - x_return_status:'||l_return_status);
284: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_renewal_type '||l_renewal_type);
285: end if;
286:
287: if(nvl(l_renewal_type,'X') <> 'EVN') then
288: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;

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

286:
287: if(nvl(l_renewal_type,'X') <> 'EVN') then
288: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
289: if(l_debug_procedure >= l_debug_runtime) then
290: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
291: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.CreateProcess ASP_ALERT_PROCESS');
292: end if;
293:
294: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:

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

287: if(nvl(l_renewal_type,'X') <> 'EVN') then
288: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
289: if(l_debug_procedure >= l_debug_runtime) then
290: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
291: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.CreateProcess ASP_ALERT_PROCESS');
292: end if;
293:
294: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
295: wf_engine.threshold := -1;

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

298: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'SERVICE_CONTRACT');
299: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_contract_id);
300: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
301: if(l_debug_procedure >= l_debug_runtime) then
302: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
303: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.CreateProcess ASP_ALERT_PROCESS');
304: end if;
305:
306: commit;

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

299: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_contract_id);
300: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
301: if(l_debug_procedure >= l_debug_runtime) then
302: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
303: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.CreateProcess ASP_ALERT_PROCESS');
304: end if;
305:
306: commit;
307: end if;

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

306: commit;
307: end if;
308: end loop;
309: if(l_debug_procedure >= l_debug_runtime) then
310: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After opening getServiceContractsDeltaRun');
311: end if;
312:
313: --program_ref_date = current_run_ref_date of this run + X of this run
314: update asp_program_run_dates