DBA Data[Home] [Help]

APPS.CS_WF_EVENT_SUBSCRIPTIONS_PKG dependencies on FND_API

Line 62: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

142: x_return_status => l_return_status,
143: x_msg_count => l_msg_count,
144: x_msg_data => l_msg_data);
145:
146: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: -- RAISE FND_API.G_EXC_ERROR ;
148: return 'SUCCESS';
149: END IF;
150: END IF ;

Line 147: -- RAISE FND_API.G_EXC_ERROR ;

143: x_msg_count => l_msg_count,
144: x_msg_data => l_msg_data);
145:
146: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: -- RAISE FND_API.G_EXC_ERROR ;
148: return 'SUCCESS';
149: END IF;
150: END IF ;
151:

Line 155: WHEN FND_API.G_EXC_ERROR THEN

151:
152: return 'SUCCESS';
153:
154: EXCEPTION
155: WHEN FND_API.G_EXC_ERROR THEN
156: return 'ERROR';
157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: return 'ERROR';

Line 158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

154: EXCEPTION
155: WHEN FND_API.G_EXC_ERROR THEN
156: return 'ERROR';
157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: return 'ERROR';
160:
161: WHEN OTHERS THEN
162: return 'ERROR';

Line 240: l_return_status := FND_API.G_RET_STS_SUCCESS;

236: a.task_id = l_task_id;
237:
238: BEGIN
239:
240: l_return_status := FND_API.G_RET_STS_SUCCESS;
241:
242: -- Get the value currently held by the "Service: Apply State Restrictions on Tasks" profile option
243: l_state_restrictions_on := FND_PROFILE.VALUE('CS_SR_ENABLE_TASK_STATE_RESTRICTIONS');
244: