89: and rownum < 2;
90:
91: BEGIN
92: l_api_name := 'Create_Content';
93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
97:
90:
91: BEGIN
92: l_api_name := 'Create_Content';
93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
97:
98: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
91: BEGIN
92: l_api_name := 'Create_Content';
93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
97:
98: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
99: if(l_debug_procedure >= l_debug_runtime) then
92: l_api_name := 'Create_Content';
93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
97:
98: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
99: if(l_debug_procedure >= l_debug_runtime) then
100: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
97:
98: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
99: if(l_debug_procedure >= l_debug_runtime) then
100: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
101: end if;
102:
103: If(funcmode = 'RUN') Then
104: l_event_entity := wf_engine.GetItemAttrText( itemtype =>itemtype,
113: itemkey =>itemkey,
114: aname =>'ALERT_SOURCE_OBJECT_ID');
115:
116: if(l_debug_procedure >= l_debug_runtime) then
117: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
118: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
119: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);
120: end if;
121:
114: aname =>'ALERT_SOURCE_OBJECT_ID');
115:
116: if(l_debug_procedure >= l_debug_runtime) then
117: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
118: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
119: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);
120: end if;
121:
122: /*
115:
116: if(l_debug_procedure >= l_debug_runtime) then
117: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
118: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
119: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);
120: end if;
121:
122: /*
123: Only Blanket Header Id is passed and Blanket Number is obtained from the query.
163:
164: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
165: --***Done SMS Content
166: if(l_debug_procedure >= l_debug_runtime) then
167: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'SMS_TEXT '||l_sms_text);
168: end if;
169:
170: --***EMAIL Content
171: --Message ASP_ORDER_EMAIL_SUB - Blanket Sales Agreement #
183: wf_engine.SetItemAttrText(itemtype, itemkey, 'EMAIL_CONTENT', l_email_content);
184: --WF_Attr EMAIL_CONTENT => Msg_Attr MSG_BODY_EMAIL
185: --***Done EMAIL Content
186: if(l_debug_procedure >= l_debug_runtime) then
187: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'BLANKETHDRID '||l_blanket_header_id);
188: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
189: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
190: end if;
191:
184: --WF_Attr EMAIL_CONTENT => Msg_Attr MSG_BODY_EMAIL
185: --***Done EMAIL Content
186: if(l_debug_procedure >= l_debug_runtime) then
187: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'BLANKETHDRID '||l_blanket_header_id);
188: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
189: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
190: end if;
191:
192: ----------
185: --***Done EMAIL Content
186: if(l_debug_procedure >= l_debug_runtime) then
187: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'BLANKETHDRID '||l_blanket_header_id);
188: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_SUB_TEXT '||l_email_sub);
189: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'EMAIL_CONTENT '||l_email_content);
190: end if;
191:
192: ----------
193: resultout := 'COMPLETE:SUCCESS';