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
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 ;
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:
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';
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';
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: