DBA Data[Home] [Help]

APPS.ASP_SERVICE_CONTENT_PROVIDER dependencies on FND_LOG

Line 106: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

102: and rownum < 2;
103:
104: BEGIN
105: l_api_name := 'Create_Content';
106: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
107: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
108: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
109: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
110:

Line 107: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

103:
104: BEGIN
105: l_api_name := 'Create_Content';
106: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
107: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
108: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
109: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
110:
111: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;

Line 108: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

104: BEGIN
105: l_api_name := 'Create_Content';
106: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
107: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
108: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
109: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
110:
111: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
112: if(l_debug_procedure >= l_debug_runtime) then

Line 109: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

105: l_api_name := 'Create_Content';
106: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
107: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
108: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
109: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
110:
111: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
112: if(l_debug_procedure >= l_debug_runtime) then
113: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);

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

109: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
110:
111: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
112: if(l_debug_procedure >= l_debug_runtime) then
113: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
114: end if;
115:
116: If(funcmode = 'RUN') Then
117: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,

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

130: itemkey =>itemkey,
131: aname =>'ALERT_SOURCE_TASK_ID');
132:
133: if(l_debug_procedure >= l_debug_runtime) then
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
135: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
136: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_task_id '||l_task_id);
138: end if;

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

131: aname =>'ALERT_SOURCE_TASK_ID');
132:
133: if(l_debug_procedure >= l_debug_runtime) then
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
135: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
136: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_task_id '||l_task_id);
138: end if;
139:

Line 136: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);

132:
133: if(l_debug_procedure >= l_debug_runtime) then
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
135: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
136: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_task_id '||l_task_id);
138: end if;
139:
140: If l_event_entity = 'SERVICE_REQUEST' Then

Line 137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_task_id '||l_task_id);

133: if(l_debug_procedure >= l_debug_runtime) then
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
135: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
136: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_task_id '||l_task_id);
138: end if;
139:
140: If l_event_entity = 'SERVICE_REQUEST' Then
141: ----------

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

181:
182: --***Done SMS Content
183:
184: if(l_debug_procedure >= l_debug_runtime) then
185: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_TEXT '||l_sms_text);
186: end if;
187:
188: --***EMAIL Content
189: --Message ASP_SERVICE_EMAIL_SUB - Service Request # for customer '' escalated.

Line 209: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'INCIDENTID '||l_incident_id);

205: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_CONTENT', l_email_content);
206: --WF_Attr EMAIL_CONTENT => Msg_Attr MSG_BODY_EMAIL
207: --***Done EMAIL Content
208: if(l_debug_procedure >= l_debug_runtime) then
209: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'INCIDENTID '||l_incident_id);
210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'TASKID '||l_task_id);
211: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
212: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
213: end if;

Line 210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'TASKID '||l_task_id);

206: --WF_Attr EMAIL_CONTENT => Msg_Attr MSG_BODY_EMAIL
207: --***Done EMAIL Content
208: if(l_debug_procedure >= l_debug_runtime) then
209: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'INCIDENTID '||l_incident_id);
210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'TASKID '||l_task_id);
211: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
212: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
213: end if;
214:

Line 211: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);

207: --***Done EMAIL Content
208: if(l_debug_procedure >= l_debug_runtime) then
209: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'INCIDENTID '||l_incident_id);
210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'TASKID '||l_task_id);
211: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
212: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
213: end if;
214:
215: ----------

Line 212: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);

208: if(l_debug_procedure >= l_debug_runtime) then
209: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'INCIDENTID '||l_incident_id);
210: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'TASKID '||l_task_id);
211: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
212: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
213: end if;
214:
215: ----------
216: resultout := 'COMPLETE:SUCCESS';