APPS.AHL_WF_NOTIFICATION_PVT dependencies on FND_API

Line 38: -- this status is FND_API.G_RET_STS_SUCCESS.

34: -- region. Up to three can be given.
35: -- p_parami_value IN Parameter values Required
36: -- x_item_key OUT Item key of the launched notification Required
37: -- x_return_status OUT Return status. Item key to be used only if Required
38: -- this status is FND_API.G_RET_STS_SUCCESS.
39: --
40: -- End of Comments
41:
42: PROCEDURE Launch_OA_Notification (

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
85: END IF;
86:
87: -- initialize procedure return status to success
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: IF (l_log_statement >= l_log_current_level) THEN
91: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||
92: ' p_object > '||p_object||

Line 161: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

157: ', x_return_status > '||x_return_status);
158: END IF;
159:
160: -- if returned with error, don't proceed any further
161: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
162: RETURN;
163: END IF;
164:
165: -- 2) get the resource id of the approver

Line 181: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

177: ', x_return_status > '||x_return_status);
178: END IF;
179:
180: -- if returned with error, don't proceed any further
181: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
182: RETURN;
183: END IF;
184:
185: -- 3) get the employee id of the approver

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188: FROM AHL_JTF_RS_EMP_V
189: WHERE resource_id = l_aprvr_resource_id;
190: EXCEPTION
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
194: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
195: p_procedure_name => l_api_name,
196: p_error_text => SUBSTR(SQLERRM,1,500));

Line 207: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

203: ', x_return_status > '||x_return_status);
204: END IF;
205:
206: -- if returned with error, don't proceed any further
207: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
208: RETURN;
209: END IF;
210:
211: -- 4) get the role for the approver

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

236: FROM AHL_JTF_RS_EMP_V
237: WHERE user_id = FND_GLOBAL.USER_ID;
238: EXCEPTION
239: WHEN OTHERS THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
242: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
243: p_procedure_name => l_api_name,
244: p_error_text => SUBSTR(SQLERRM,1,500));

Line 255: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

251: ', x_return_status > '||x_return_status);
252: END IF;
253:
254: -- if returned with error, don't proceed any further
255: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
256: RETURN;
257: END IF;
258:
259: -- 2) get the role for the requester

Line 286: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

282: itemkey => l_item_key);
283: -- **********************************************************************************
284:
285: -- if no errors occurred, set the item key
286: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
287: x_item_key := l_item_key;
288: END IF;
289:
290: IF (l_log_procedure >= l_log_current_level) THEN