DBA Data[Home] [Help]

APPS.EAM_WO_UTILITY_PVT dependencies on FND_API

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

39: , x_Return_status OUT NOCOPY VARCHAR2
40: )
41: IS
42: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
43: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
44: l_dummy varchar2(10);
45: BEGIN
46:
47: SELECT we.wip_entity_name

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

254: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
255: x_eam_wo_rec := l_eam_wo_rec;
256:
257: WHEN OTHERS THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: x_eam_wo_rec := l_eam_wo_rec;
260:
261: END Query_Row;
262:

Line 290: x_return_status := fnd_api.g_ret_sts_error;

286: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing EAM WO rec for ' || p_eam_wo_rec.wip_entity_name); END IF;
287:
288: -- bug no 3444091
289: if p_eam_wo_rec.scheduled_start_date > p_eam_wo_rec.scheduled_completion_date then
290: x_return_status := fnd_api.g_ret_sts_error;
291: fnd_message.set_name('EAM','EAM_WO_WORKORDER_DT_ERR');
292: return;
293: end if;
294:

Line 604: x_return_status := FND_API.G_RET_STS_SUCCESS;

600: );
601:
602:
603: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Work Order') ; END IF;
604: x_return_status := FND_API.G_RET_STS_SUCCESS;
605:
606:
607: EXCEPTION
608: WHEN OTHERS THEN

Line 615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

611: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
612: , x_mesg_token_Tbl => x_mesg_token_tbl
613: );
614:
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616:
617: END Insert_Row;
618:
619: /********************************************************************

Line 641: x_return_status := fnd_api.g_ret_sts_error;

637: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating EAM WO '|| p_eam_wo_rec.wip_entity_name); END IF;
638:
639: -- bug no 3444091
640: if p_eam_wo_rec.scheduled_start_date > p_eam_wo_rec.scheduled_completion_date then
641: x_return_status := fnd_api.g_ret_sts_error;
642: fnd_message.set_name('EAM','EAM_WO_WORKORDER_DT_ERR');
643: return;
644: end if;
645:

Line 776: x_return_status := FND_API.G_RET_STS_SUCCESS;

772: , last_update_login = FND_GLOBAL.login_id
773: WHERE wip_entity_id = p_eam_wo_rec.wip_entity_id
774: AND organization_id = p_eam_wo_rec.organization_id;
775:
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777:
778: END Update_Row;
779:
780: /*********************************************************************

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

793: , x_return_status OUT NOCOPY VARCHAR2
794: )
795: IS
796: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
797: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
798: BEGIN
799:
800: IF p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
801: THEN