33: BEGIN
34: IF l_debug_level > 0 THEN
35: oe_debug_pub.add( 'CHKPROCCONSTRAINTS: CALLING SECURITY FOR KEY ' || X_SEC_REQ.WF_ITEM_KEY || ' WITH RESP ID ' || TO_CHAR ( X_SEC_REQ.RESPONSIBILITY_ID ) ) ;
36: END IF;
37: x_return_status := FND_API.G_RET_STS_ERROR;
38: x_result := FND_API.G_FALSE;
39: -- call processing constraints api
40: /* l_rslt := OE_PC_CONSTRAINTS_MANAGER_PUB.Is_Entity_Op_Constrained(
41: p_api_version => '1.0'
34: IF l_debug_level > 0 THEN
35: oe_debug_pub.add( 'CHKPROCCONSTRAINTS: CALLING SECURITY FOR KEY ' || X_SEC_REQ.WF_ITEM_KEY || ' WITH RESP ID ' || TO_CHAR ( X_SEC_REQ.RESPONSIBILITY_ID ) ) ;
36: END IF;
37: x_return_status := FND_API.G_RET_STS_ERROR;
38: x_result := FND_API.G_FALSE;
39: -- call processing constraints api
40: /* l_rslt := OE_PC_CONSTRAINTS_MANAGER_PUB.Is_Entity_Op_Constrained(
41: p_api_version => '1.0'
42: ,p_application_id => x_sec_req.application_id
72: (G_PKG_NAME
73: ,'ChkProcConstraints'
74: ,'wfx_constraintsManager_pub.isOperationConstrained Returned unexpected error');
75: END IF;
76: raise FND_API.G_EXC_UNEXPECTED_ERROR;
77: elsif (l_rslt =wfx_constraintsManager_pub.G_yes) --Security constraint exists,
78: -- Cancellation not permitted.
79: then
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
76: raise FND_API.G_EXC_UNEXPECTED_ERROR;
77: elsif (l_rslt =wfx_constraintsManager_pub.G_yes) --Security constraint exists,
78: -- Cancellation not permitted.
79: then
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: x_result := FND_API.G_FALSE;
82: else
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84: x_result := FND_API.G_TRUE;
77: elsif (l_rslt =wfx_constraintsManager_pub.G_yes) --Security constraint exists,
78: -- Cancellation not permitted.
79: then
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: x_result := FND_API.G_FALSE;
82: else
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84: x_result := FND_API.G_TRUE;
85: end if; */
79: then
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: x_result := FND_API.G_FALSE;
82: else
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84: x_result := FND_API.G_TRUE;
85: end if; */
86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: x_result := FND_API.G_FALSE;
82: else
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84: x_result := FND_API.G_TRUE;
85: end if; */
86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84: x_result := FND_API.G_TRUE;
85: end if; */
86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: x_result := FND_API.G_FALSE;
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: x_result := FND_API.G_TRUE;
85: end if; */
86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: x_result := FND_API.G_FALSE;
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_result := FND_API.G_FALSE;
85: end if; */
86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: x_result := FND_API.G_FALSE;
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_result := FND_API.G_FALSE;
93: WHEN OTHERS THEN
86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: x_result := FND_API.G_FALSE;
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_result := FND_API.G_FALSE;
93: WHEN OTHERS THEN
94: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
87: WHEN FND_API.G_EXC_ERROR THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: x_result := FND_API.G_FALSE;
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_result := FND_API.G_FALSE;
93: WHEN OTHERS THEN
94: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
95: FND_MSG_PUB.Add_Exc_Msg
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: x_result := FND_API.G_FALSE;
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_result := FND_API.G_FALSE;
93: WHEN OTHERS THEN
94: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
95: FND_MSG_PUB.Add_Exc_Msg
96: (G_PKG_NAME
95: FND_MSG_PUB.Add_Exc_Msg
96: (G_PKG_NAME
97: ,'ChkProcConstraints');
98: END IF;
99: x_return_status := FND_API.G_RET_STS_ERROR;
100: x_result := FND_API.G_FALSE;
101: END ChkProcConstraints;
102:
103: END;
96: (G_PKG_NAME
97: ,'ChkProcConstraints');
98: END IF;
99: x_return_status := FND_API.G_RET_STS_ERROR;
100: x_result := FND_API.G_FALSE;
101: END ChkProcConstraints;
102:
103: END;