DBA Data[Home] [Help]

APPS.ASP_SVCCONT_CONTENT_PROVIDER dependencies on FND_LOG

Line 96: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

92: and rownum < 2;
93:
94: BEGIN
95: l_api_name := 'Create_Content';
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:

Line 97: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

93:
94: BEGIN
95: l_api_name := 'Create_Content';
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:
101: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;

Line 98: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

94: BEGIN
95: l_api_name := 'Create_Content';
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:
101: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
102: if(l_debug_procedure >= l_debug_runtime) then

Line 99: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

95: l_api_name := 'Create_Content';
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:
101: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
102: if(l_debug_procedure >= l_debug_runtime) then
103: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);

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

99: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
100:
101: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
102: if(l_debug_procedure >= l_debug_runtime) then
103: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
104: end if;
105:
106: If(funcmode = 'RUN') Then
107: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,

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

116: itemkey =>itemkey,
117: aname =>'ALERT_SOURCE_OBJECT_ID');
118:
119: if(l_debug_procedure >= l_debug_runtime) then
120: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
121: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
122: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);
123: end if;
124:

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

117: aname =>'ALERT_SOURCE_OBJECT_ID');
118:
119: if(l_debug_procedure >= l_debug_runtime) then
120: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
121: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
122: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);
123: end if;
124:
125: If l_event_entity = 'SERVICE_CONTRACT' Then

Line 122: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);

118:
119: if(l_debug_procedure >= l_debug_runtime) then
120: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
121: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
122: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);
123: end if;
124:
125: If l_event_entity = 'SERVICE_CONTRACT' Then
126: ----------

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

159:
160: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
161: --***Done SMS Content
162: if(l_debug_procedure >= l_debug_runtime) then
163: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_TEXT '||l_sms_text);
164: end if;
165:
166: --***EMAIL Content
167: --Message ASP_SVCCON_EMAIL_SUB - Contract # for customer '' expires shortly

Line 183: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'CONTRACTID '||l_contract_header_id);

179: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_CONTENT', l_email_content);
180: --WF_Attr EMAIL_CONTENT => Msg_Attr MSG_BODY_EMAIL
181: --***Done EMAIL Content
182: if(l_debug_procedure >= l_debug_runtime) then
183: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'CONTRACTID '||l_contract_header_id);
184: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
185: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
186: end if;
187:

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

180: --WF_Attr EMAIL_CONTENT => Msg_Attr MSG_BODY_EMAIL
181: --***Done EMAIL Content
182: if(l_debug_procedure >= l_debug_runtime) then
183: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'CONTRACTID '||l_contract_header_id);
184: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
185: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
186: end if;
187:
188: ----------

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

181: --***Done EMAIL Content
182: if(l_debug_procedure >= l_debug_runtime) then
183: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'CONTRACTID '||l_contract_header_id);
184: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
185: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
186: end if;
187:
188: ----------
189: resultout := 'COMPLETE:SUCCESS';