DBA Data[Home] [Help]

APPS.EAM_ESTABLISHMENT_UTILITY_PVT dependencies on FND_API

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

149: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
150: x_safety_establishment_rec := l_safety_establishment_rec;
151:
152: WHEN OTHERS THEN
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: x_safety_establishment_rec := l_safety_establishment_rec;
155:
156: END QUERY_ROW;
157:

Line 281: x_return_status := FND_API.G_RET_STS_SUCCESS;

277: ,SYSDATE
278: ,FND_GLOBAL.user_id
279: ,FND_GLOBAL.login_id);
280:
281: x_return_status := FND_API.G_RET_STS_SUCCESS;
282:
283:
284: EXCEPTION
285: WHEN OTHERS THEN

Line 286: x_return_status := fnd_api.g_ret_sts_error;

282:
283:
284: EXCEPTION
285: WHEN OTHERS THEN
286: x_return_status := fnd_api.g_ret_sts_error;
287:
288: END INSERT_ROW;
289:
290:

Line 361: x_return_status := FND_API.G_RET_STS_SUCCESS;

357: ,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
358: WHERE establishment_id = p_safety_establishment_rec.establishment_id
359: AND organization_id = p_safety_establishment_rec.organization_id;
360:
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362: EXCEPTION
363: WHEN OTHERS THEN
364: x_return_status := fnd_api.g_ret_sts_error;
365:

Line 364: x_return_status := fnd_api.g_ret_sts_error;

360:
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362: EXCEPTION
363: WHEN OTHERS THEN
364: x_return_status := fnd_api.g_ret_sts_error;
365:
366: END UPDATE_ROW;
367:
368: /********************************************************************

Line 384: x_return_status := FND_API.G_RET_STS_SUCCESS;

380: DELETE FROM EAM_ESTABLISHMENT_DETAILS
381: WHERE establishment_id =p_safety_establishment_rec.establishment_id
382: AND organization_id = p_organization_id;
383:
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385:
386: EXCEPTION
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_ERROR;

Line 388: x_return_status := FND_API.G_RET_STS_ERROR;

384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385:
386: EXCEPTION
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: END DELETE_ROW;
390:
391:
392: /********************************************************************

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

399: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
400: , x_return_Status OUT NOCOPY VARCHAR2
401: ) IS
402: l_msg_data VARCHAR2(240);
403: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
404:
405: BEGIN
406:
407: IF p_safety_establishment_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

Line 435: x_return_status := fnd_api.g_ret_sts_error;

431: x_return_status := l_return_status;
432:
433: EXCEPTION
434: WHEN OTHERS THEN
435: x_return_status := fnd_api.g_ret_sts_error;
436:
437:
438: END PERFORM_WRITES;
439:

Line 454: x_return_status:= FND_API.G_RET_STS_SUCCESS;

450: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
451: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
452: BEGIN
453: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Isolation . . . '); END IF;
454: x_return_status:= FND_API.G_RET_STS_SUCCESS;
455: IF p_safety_establishment_rec.ESTABLISHMENT_ID IS NULL THEN
456: l_out_mesg_token_tbl := l_mesg_token_tbl;
457: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
458: p_message_name => 'EAM_ESTAB_ID_REQUIRED' ,

Line 463: x_return_status := FND_API.G_RET_STS_ERROR;

459: p_token_tbl => l_Token_tbl ,
460: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
461: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
462: l_mesg_token_tbl := l_out_mesg_token_tbl;
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: END IF;
465: IF p_safety_establishment_rec.ESTABLISHMENT_SOURCE IS NULL THEN
466: l_out_mesg_token_tbl := l_mesg_token_tbl;
467: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 473: x_return_status := FND_API.G_RET_STS_ERROR;

469: p_token_tbl => l_Token_tbl ,
470: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
471: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
472: l_mesg_token_tbl := l_out_mesg_token_tbl;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: END IF;
475: IF p_safety_establishment_rec.SEQUENCE_TYPE IS NULL THEN
476: l_out_mesg_token_tbl := l_mesg_token_tbl;
477: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 483: x_return_status := FND_API.G_RET_STS_ERROR;

479: p_token_tbl => l_Token_tbl ,
480: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
481: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
482: l_mesg_token_tbl := l_out_mesg_token_tbl;
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: END IF;
485:
486: IF p_safety_establishment_rec.SEQUENCE_NUMBER IS NULL THEN
487: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 494: x_return_status := FND_API.G_RET_STS_ERROR;

490: p_token_tbl => l_Token_tbl ,
491: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
492: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
493: l_mesg_token_tbl := l_out_mesg_token_tbl;
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: END IF;
496:
497: IF p_safety_establishment_rec.MAINTENANCE_OBJECT_ID IS NULL
498: THEN

Line 507: x_return_status := FND_API.G_RET_STS_ERROR;

503: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
504: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
505: );
506: l_mesg_token_tbl := l_out_mesg_token_tbl;
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: END IF;
509:
510: IF p_safety_establishment_rec.ORGANIZATION_ID IS NULL THEN
511: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 518: x_return_status := FND_API.G_RET_STS_ERROR;

514: p_token_tbl => l_Token_tbl ,
515: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
516: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
517: l_mesg_token_tbl := l_out_mesg_token_tbl;
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: END IF;
520:
521: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
522: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 522: x_return_status := FND_API.G_RET_STS_SUCCESS;

518: x_return_status := FND_API.G_RET_STS_ERROR;
519: END IF;
520:
521: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523: END CHECK_REQUIRED;
524:
525: END EAM_ESTABLISHMENT_UTILITY_PVT ;
526: