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

Line 87: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

83: and r.object_id IS NOT NULL;
84:
85: BEGIN
86: l_api_name := 'Initiate_Alerts';
87: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
88: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
89: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
90: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
91:

Line 88: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

84:
85: BEGIN
86: l_api_name := 'Initiate_Alerts';
87: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
88: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
89: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
90: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
91:
92: if(l_debug_procedure >= l_debug_runtime) then

Line 89: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

85: BEGIN
86: l_api_name := 'Initiate_Alerts';
87: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
88: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
89: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
90: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
91:
92: if(l_debug_procedure >= l_debug_runtime) then
93: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);

Line 90: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

86: l_api_name := 'Initiate_Alerts';
87: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
88: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
89: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
90: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
91:
92: if(l_debug_procedure >= l_debug_runtime) then
93: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
94: end if;

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

89: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
90: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
91:
92: if(l_debug_procedure >= l_debug_runtime) then
93: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
94: end if;
95:
96: save_threshold := wf_engine.threshold;
97: l_event_name := p_event.getEventName();

Line 101: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_name='||l_event_name);

97: l_event_name := p_event.getEventName();
98: -- Detect the event raised and determine necessary parameters depending on the event.
99:
100: if(l_debug_procedure >= l_debug_runtime) then
101: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_name='||l_event_name);
102: end if;
103:
104: If(l_event_name = G_ESC_SERVICE_REQUEST_EVENT) Then
105: l_event_key := p_event.GetValueForParameter('TASK_ID');

Line 107: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_key='||l_event_key);

103:
104: If(l_event_name = G_ESC_SERVICE_REQUEST_EVENT) Then
105: l_event_key := p_event.GetValueForParameter('TASK_ID');
106: if(l_debug_procedure >= l_debug_runtime) then
107: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_key='||l_event_key);
108: end if;
109: FOR get_esc_details_rec IN get_ref_sr(l_event_key)
110: LOOP
111: l_incident_id := get_esc_details_rec.object_id ;

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

115: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
116: wf_engine.threshold := -1;
117: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
118: if(l_debug_procedure >= l_debug_runtime) then
119: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key='||l_item_key);
120: end if;
121:
122: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'SVCREQUEST_ESCALATED_ALERT');
123: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'SERVICE_REQUEST');

Line 127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.StartProcess');

123: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'SERVICE_REQUEST');
124: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_incident_id);
125: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_TASK_ID', l_event_key);
126: if(l_debug_procedure >= l_debug_runtime) then
127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.StartProcess');
128: end if;
129: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
130: if(l_debug_procedure >= l_debug_runtime) then
131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.StartProcess');

Line 131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.StartProcess');

127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.StartProcess');
128: end if;
129: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
130: if(l_debug_procedure >= l_debug_runtime) then
131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.StartProcess');
132: end if;
133: commit;
134:
135: END LOOP;

Line 140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Subscription - CUSTOM Event');

136: ELSE
137: --Custom Events
138: -- Construct the unique item key
139: if(l_debug_procedure >= l_debug_runtime) then
140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Subscription - CUSTOM Event');
141: end if;
142: SELECT to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
143:
144: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:

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

144: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
145: wf_engine.threshold := -1;
146: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
147: if(l_debug_procedure >= l_debug_runtime) then
148: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key='||l_item_key);
149: end if;
150:
151: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', l_event_name);
152: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'CUSTOM');

Line 171: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.StartProcess');

167: end loop;
168: end if;
169:
170: if(l_debug_procedure >= l_debug_runtime) then
171: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.StartProcess');
172: end if;
173: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
174: if(l_debug_procedure >= l_debug_runtime) then
175: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.StartProcess');

Line 175: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.StartProcess');

171: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.StartProcess');
172: end if;
173: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
174: if(l_debug_procedure >= l_debug_runtime) then
175: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After wf_engine.StartProcess');
176: end if;
177: commit;
178:
179: END IF;

Line 189: fnd_log.string(l_debug_exception, G_MODULE||l_api_name,

185: WF_CORE.CONTEXT(G_PKG_NAME, l_api_name, l_event_name, p_subscription_guid);
186: WF_EVENT.setErrorInfo(p_event, 'WARNING');
187: wf_engine.threshold := save_threshold;
188: if(l_debug_exception >= l_debug_runtime) then
189: fnd_log.string(l_debug_exception, G_MODULE||l_api_name,
190: 'Leaving '||G_PKG_NAME||'.'||l_api_name||'with exceptions' ||
191: to_char(SQLCODE)||':'||substr(SQLERRM,1,500));
192: end if;
193: return 'WARNING';