DBA Data[Home] [Help]

APPS.EAM_SAFETY_UTILITY_PVT dependencies on FND_API

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

118: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
119: x_safety_association_rec := l_safety_association_rec;
120:
121: WHEN OTHERS THEN
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: x_safety_association_rec := l_safety_association_rec;
124:
125:
126: END QUERY_SAFFETY_ASSOCIATION_ROWS;

Line 242: x_return_status := FND_API.G_RET_STS_SUCCESS;

238: ,SYSDATE
239: ,FND_GLOBAL.user_id
240: ,FND_GLOBAL.login_id);
241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243: EXCEPTION
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243: EXCEPTION
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: END INSERT_SAFFETY_ASSOCIATION_ROW;
248:
249:

Line 314: x_return_status := FND_API.G_RET_STS_SUCCESS;

310:
311: WHERE SAFETY_ASSOCIATION_ID=p_safety_association_rec.SAFETY_ASSOCIATION_ID
312: AND ASSOCIATION_TYPE=p_safety_association_rec.ASSOCIATION_TYPE;
313:
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: EXCEPTION
317: WHEN OTHERS THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: EXCEPTION
317: WHEN OTHERS THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319:
320: END UPDATE_SAFFETY_ASSOCIATION_ROW;
321:
322:

Line 355: x_return_status := FND_API.G_RET_STS_SUCCESS;

351: DELETE FROM EAM_SAFETY_ASSOCIATIONS
352: WHERE SAFETY_ASSOCIATION_ID =p_safety_association_rec.SAFETY_ASSOCIATION_ID
353: AND ASSOCIATION_TYPE = p_association_type;
354:
355: x_return_status := FND_API.G_RET_STS_SUCCESS;
356:
357: EXCEPTION
358: WHEN OTHERS THEN
359: x_return_status := FND_API.G_RET_STS_ERROR;

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

355: x_return_status := FND_API.G_RET_STS_SUCCESS;
356:
357: EXCEPTION
358: WHEN OTHERS THEN
359: x_return_status := FND_API.G_RET_STS_ERROR;
360:
361: END DELETE_SAFFETY_ASSOCIATION_ROW;
362:
363:

Line 378: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

374: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
375: , x_return_Status OUT NOCOPY VARCHAR2
376: ) IS
377:
378: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
379: BEGIN
380: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing Safety Association Row'); END IF;
381:
382: IF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE