APPS.CS_WF_EVENT_SUBSCRIPTIONS_PKG dependencies on FND_API

Line 63: l_return_status := FND_API.G_RET_STS_SUCCESS;

59: l_status_prop_flag VARCHAR2(3) := 'N' ;
60:
61: BEGIN
62:
63: l_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: FND_PROFILE.GET('CS_SR_AUTO_CLOSE_SR',l_auto_close_profile);
66:
67: IF nvl(l_auto_close_profile, 'NO') <> 'YES' THEN

Line 159: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

155: x_return_status => l_return_status,
156: x_msg_count => l_msg_count,
157: x_msg_data => l_msg_data);
158:
159: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
160: -- RAISE FND_API.G_EXC_ERROR ;
161: return 'SUCCESS';
162: END IF;
163: END IF ;

Line 160: -- RAISE FND_API.G_EXC_ERROR ;

156: x_msg_count => l_msg_count,
157: x_msg_data => l_msg_data);
158:
159: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
160: -- RAISE FND_API.G_EXC_ERROR ;
161: return 'SUCCESS';
162: END IF;
163: END IF ;
164:

Line 168: WHEN FND_API.G_EXC_ERROR THEN

164:
165: return 'SUCCESS';
166:
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: return 'ERROR';
170:
171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
172: return 'ERROR';

Line 171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: return 'ERROR';
170:
171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
172: return 'ERROR';
173:
174: WHEN OTHERS THEN
175: return 'ERROR';

Line 253: l_return_status := FND_API.G_RET_STS_SUCCESS;

249: a.task_id = l_task_id;
250:
251: BEGIN
252:
253: l_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: -- Get the value currently held by the "Service: Apply State Restrictions on Tasks" profile option
256: l_state_restrictions_on := FND_PROFILE.VALUE('CS_SR_ENABLE_TASK_STATE_RESTRICTIONS');
257: