DBA Data[Home] [Help]

APPS.GMD_SS_APPROVAL_WF_PKG dependencies on WF_CORE

Line 156: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,'NO VLAID SS ROW');

152: -- Get attributes Required for display
153: open get_disp_Attr;
154: FETCH get_disp_Attr INTO disp_attr_rec;
155: IF get_disp_Attr%NOTFOUND THEN
156: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,'NO VLAID SS ROW');
157: raise APPLICATION_ERROR;
158: END IF;
159: close get_disp_Attr;
160:

Line 209: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,'NO VLAID SS ROW');

205: -- Get attributes Required for display
206: open get_disp_Attr;
207: FETCH get_disp_Attr INTO disp_attr_rec;
208: IF get_disp_Attr%NOTFOUND THEN
209: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,'NO VLAID SS ROW');
210: raise APPLICATION_ERROR;
211: END IF;
212:
213: open get_storage_name(disp_attr_rec.storage_plan_id);

Line 278: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

274:
275:
276: p_resultout := 'COMPLETE:Y';
277: ELSE
278: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
279: raise APPLICATION_ERROR;
280: END IF;
281:
282: END IF;

Line 285: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,'Invalid SS ID');

281:
282: END IF;
283:
284: EXCEPTION WHEN NO_DATA_FOUND THEN
285: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,'Invalid SS ID');
286: raise;
287: END IS_APPROVAL_REQ;
288:
289: /**************************************************************************************

Line 310: --l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING

306: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_CURR_PERFORMER');
307: BEGIN
308: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
309: BEGIN
310: --l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING
311: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||
312: wf_core.newline||l_comment;
313: l_comment := null;
314: EXCEPTION WHEN OTHERS THEN

Line 311: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||

307: BEGIN
308: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
309: BEGIN
310: --l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING
311: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||
312: wf_core.newline||l_comment;
313: l_comment := null;
314: EXCEPTION WHEN OTHERS THEN
315: NULL;

Line 312: wf_core.newline||l_comment;

308: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
309: BEGIN
310: --l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING
311: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||
312: wf_core.newline||l_comment;
313: l_comment := null;
314: EXCEPTION WHEN OTHERS THEN
315: NULL;
316: END;

Line 388: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

384: , x_message => api_err_mesg );
385:
386:
387: IF api_ret_status <> 'S' THEN
388: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
389: raise APPLICATION_ERROR;
390: END IF;
391:
392: IF (l_debug = 'Y') THEN

Line 495: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

491: , x_return_status => api_ret_status
492: , x_message => api_err_mesg );
493:
494: IF api_ret_status <> 'S' THEN
495: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
496: raise APPLICATION_ERROR;
497: END IF;
498: END IF;
499: END NO_RESPONSE;

Line 563: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

559: , x_return_status => api_ret_status
560: , x_message => api_err_mesg );
561:
562: IF api_ret_status <> 'S' THEN
563: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
564: raise APPLICATION_ERROR;
565: END IF;
566: END IF;
567: