181: l_plan_processing_code = 'G'
182: THEN
183: -- Success!
184:
185: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_SUCCESS');
186: l_msg_subj_text := FND_MESSAGE.GET;
187:
188: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_SUCCESS');
189: l_msg_desc_text := FND_MESSAGE.GET;
182: THEN
183: -- Success!
184:
185: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_SUCCESS');
186: l_msg_subj_text := FND_MESSAGE.GET;
187:
188: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_SUCCESS');
189: l_msg_desc_text := FND_MESSAGE.GET;
190:
184:
185: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_SUCCESS');
186: l_msg_subj_text := FND_MESSAGE.GET;
187:
188: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_SUCCESS');
189: l_msg_desc_text := FND_MESSAGE.GET;
190:
191: wf_engine.SetItemAttrText
192: ( itemtype => itemtype
185: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_SUCCESS');
186: l_msg_subj_text := FND_MESSAGE.GET;
187:
188: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_SUCCESS');
189: l_msg_desc_text := FND_MESSAGE.GET;
190:
191: wf_engine.SetItemAttrText
192: ( itemtype => itemtype
193: , itemkey => itemkey
204:
205: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
206: l_plan_processing_code = 'E'
207: THEN
208: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
209: l_msg_subj_text := FND_MESSAGE.GET;
210:
211: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FCST_LINE_FAILURE');
212: l_msg_desc_text := FND_MESSAGE.GET;
205: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
206: l_plan_processing_code = 'E'
207: THEN
208: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
209: l_msg_subj_text := FND_MESSAGE.GET;
210:
211: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FCST_LINE_FAILURE');
212: l_msg_desc_text := FND_MESSAGE.GET;
213:
207: THEN
208: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
209: l_msg_subj_text := FND_MESSAGE.GET;
210:
211: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FCST_LINE_FAILURE');
212: l_msg_desc_text := FND_MESSAGE.GET;
213:
214: -- Errors! Note that the WF only marked as failure if ORA error
215:
208: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
209: l_msg_subj_text := FND_MESSAGE.GET;
210:
211: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FCST_LINE_FAILURE');
212: l_msg_desc_text := FND_MESSAGE.GET;
213:
214: -- Errors! Note that the WF only marked as failure if ORA error
215:
216: wf_engine.SetItemAttrText
250: );
251:
252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
253:
254: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
255: l_msg_subj_text := FND_MESSAGE.GET;
256:
257: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_FAILURE');
258: l_msg_desc_text := FND_MESSAGE.GET;
251:
252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
253:
254: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
255: l_msg_subj_text := FND_MESSAGE.GET;
256:
257: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_FAILURE');
258: l_msg_desc_text := FND_MESSAGE.GET;
259:
253:
254: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
255: l_msg_subj_text := FND_MESSAGE.GET;
256:
257: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_FAILURE');
258: l_msg_desc_text := FND_MESSAGE.GET;
259:
260: wf_engine.SetItemAttrText
261: ( itemtype => itemtype
254: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
255: l_msg_subj_text := FND_MESSAGE.GET;
256:
257: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_FAILURE');
258: l_msg_desc_text := FND_MESSAGE.GET;
259:
260: wf_engine.SetItemAttrText
261: ( itemtype => itemtype
262: , itemkey => itemkey
285: resultout := wf_engine.eng_completed||':'||'U';
286:
287: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
288:
289: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
290: l_msg_subj_text := FND_MESSAGE.GET;
291:
292: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_FAILURE');
293: l_msg_desc_text := FND_MESSAGE.GET;
286:
287: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
288:
289: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
290: l_msg_subj_text := FND_MESSAGE.GET;
291:
292: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_FAILURE');
293: l_msg_desc_text := FND_MESSAGE.GET;
294:
288:
289: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
290: l_msg_subj_text := FND_MESSAGE.GET;
291:
292: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_FAILURE');
293: l_msg_desc_text := FND_MESSAGE.GET;
294:
295: wf_engine.SetItemAttrText
296: ( itemtype => itemtype
289: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_FORECAST_FAILURE');
290: l_msg_subj_text := FND_MESSAGE.GET;
291:
292: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_FORECAST_FAILURE');
293: l_msg_desc_text := FND_MESSAGE.GET;
294:
295: wf_engine.SetItemAttrText
296: ( itemtype => itemtype
297: , itemkey => itemkey
305: , aname => 'MSG_DESCRIPTION_FYI'
306: , avalue => l_msg_desc_text
307: );
308:
309: FND_MESSAGE.SET_NAME ('PA','PA_NFERR_FCST');
310: l_msg_err_text := FND_MESSAGE.GET;
311:
312: wf_engine.SetItemAttrText
313: ( itemtype => itemtype
306: , avalue => l_msg_desc_text
307: );
308:
309: FND_MESSAGE.SET_NAME ('PA','PA_NFERR_FCST');
310: l_msg_err_text := FND_MESSAGE.GET;
311:
312: wf_engine.SetItemAttrText
313: ( itemtype => itemtype
314: , itemkey => itemkey
377: END IF;
378:
379: IF p_msg_count = 1 THEN
380: IF p_msg_data IS NOT NULL THEN
381: FND_MESSAGE.SET_ENCODED (p_msg_data);
382: l_data := FND_MESSAGE.GET;
383: wf_engine.SetItemAttrText
384: ( itemtype => p_item_type
385: , itemkey => p_item_key
378:
379: IF p_msg_count = 1 THEN
380: IF p_msg_data IS NOT NULL THEN
381: FND_MESSAGE.SET_ENCODED (p_msg_data);
382: l_data := FND_MESSAGE.GET;
383: wf_engine.SetItemAttrText
384: ( itemtype => p_item_type
385: , itemkey => p_item_key
386: , aname => 'ERROR_COMMENTS_1'