DBA Data[Home] [Help]

APPS.GMD_SS_APPROVAL_WF_PKG dependencies on GMD_SS_APPROVAL_WF_PKG

Line 1: PACKAGE BODY GMD_SS_APPROVAL_WF_PKG AS

1: PACKAGE BODY GMD_SS_APPROVAL_WF_PKG AS
2: /* $Header: GMDQMSAB.pls 120.3.12000000.3 2007/02/07 12:09:49 rlnagara ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

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 231: lStartStatus_DESC := GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'STABILITY');

227: END IF;
228:
229: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);
230: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER);
231: lStartStatus_DESC := GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'STABILITY');
232: lTargetStatus_DESC:= GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'STABILITY');
233:
234: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE);
235: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);

Line 232: lTargetStatus_DESC:= GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'STABILITY');

228:
229: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);
230: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER);
231: lStartStatus_DESC := GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'STABILITY');
232: lTargetStatus_DESC:= GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'STABILITY');
233:
234: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE);
235: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
236: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC',disp_attr_rec.SPEC_NAME);

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 387: WF_CORE.CONTEXT ('GMD_SS_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

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

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

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

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

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

Line 697: END GMD_SS_APPROVAL_WF_PKG;

693: p_parameters => l_parameter_list);
694: l_parameter_list.DELETE;
695: END;
696:
697: END GMD_SS_APPROVAL_WF_PKG;