DBA Data[Home] [Help]

APPS.ASP_ORDER_CONTENT_PROVIDER dependencies on FND_LOG

Line 93: l_debug_runtime := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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:

Line 94: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;

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;

Line 95: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;

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

Line 96: l_debug_statment := FND_LOG.LEVEL_STATEMENT;

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);

Line 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,

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

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:

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

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: /*

Line 119: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_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: /*
123: Only Blanket Header Id is passed and Blanket Number is obtained from the query.

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

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 # for customer '' expires shortly

Line 187: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'BLANKETHDRID '||l_blanket_header_id);

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:

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

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: ----------

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

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';