DBA Data[Home] [Help]

APPS.CS_SR_SECURITY_GRP dependencies on FND_API

Line 27: x_return_status := FND_API.G_RET_STS_SUCCESS;

23: l_api_name_full VARCHAR2(70):= G_PKG_NAME||'.'||'VALIDATE_USER_RESPONSIBILITY';
24:
25: BEGIN
26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: OPEN c_sr_access_csr;
30: FETCH c_sr_access_csr INTO l_access_status;
31:

Line 45: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

41:
42: EXCEPTION
43: WHEN OTHERS THEN
44: close c_sr_access_csr;
45: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
46: x_resp_access_status := 'N';
47: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
48: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
49: fnd_msg_pub.add;

Line 81: x_return_status := FND_API.G_RET_STS_SUCCESS;

77: j NUMBER := 1;
78:
79: BEGIN
80:
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: -- set the SR Type id context with the passed in SR type.
84: CS_SR_SECURITY_CONTEXT.SET_SR_SECURITY_CONTEXT (
85: p_context_attribute => 'SRTYPE_ID',

Line 108: x_return_status := FND_API.G_RET_STS_SUCCESS;

104: end if; -- if ( px_resource_tbl(i).resource_type NOT IN ('RS_GROUP', 'RS_TEAM'
105: END LOOP;
106:
107: px_resource_tbl := lx_resource_tbl;
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: EXCEPTION
111: WHEN OTHERS THEN
112: if ( c_resource_csr%ISOPEN ) then

Line 119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

115:
116: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
117: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
118: fnd_msg_pub.ADD;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120: END Validate_Resource;
121:
122: END CS_SR_SECURITY_GRP;