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:
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;
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
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);
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,
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:
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
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: ----------
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 #
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:
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: ----------
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';