APPS.EAM_RES_UTILITY_PVT dependencies on FND_API

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

44: , x_Return_status OUT NOCOPY VARCHAR2
45: )
46: IS
47: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
48: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
49: l_dummy varchar2(10);
50: BEGIN
51:
52: SELECT

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

135: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
136: x_eam_res_rec := l_eam_res_rec;
137:
138: WHEN OTHERS THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: x_eam_res_rec := l_eam_res_rec;
141:
142: END Query_Row;
143:

Line 170: x_return_status := fnd_api.g_ret_sts_error;

166: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Resource rec for ' || p_eam_res_rec.resource_seq_num); END IF;
167:
168: -- bug no 3444091
169: if p_eam_res_rec.start_date > p_eam_res_rec.completion_date then
170: x_return_status := fnd_api.g_ret_sts_error;
171: fnd_message.set_name('EAM','EAM_WO_RR_DT_ERR');
172: return;
173: end if;
174:

Line 277: x_return_status := FND_API.G_RET_STS_SUCCESS;

273:
274: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new resources') ; END IF;
275:
276:
277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278:
279: -- API is called to set the estimation_status
280: EAM_AutomaticEst.Auto_Reest_of_Cost(
281: p_wip_entity_id => p_eam_res_rec.wip_entity_id,

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
300: , x_mesg_token_Tbl => x_mesg_token_tbl
301: );
302:
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304:
305: END Insert_Row;
306:
307: /********************************************************************

Line 333: x_return_status := fnd_api.g_ret_sts_error;

329: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Resource: '|| p_eam_res_rec.resource_seq_num); END IF;
330:
331: -- bug no 3444091
332: if p_eam_res_rec.start_date > p_eam_res_rec.completion_date then
333: x_return_status := fnd_api.g_ret_sts_error;
334: fnd_message.set_name('EAM','EAM_WO_RR_DT_ERR');
335: return;
336: end if;
337:

Line 396: x_return_status := FND_API.G_RET_STS_SUCCESS;

392: AND resource_seq_num = p_eam_res_rec.resource_seq_num;
393:
394: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Updating resources') ; END IF;
395:
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397:
398: -- comparing new usage rate with existing
399: IF ( p_eam_res_rec.usage_rate_or_amount <> l_usage_rate_or_amount )THEN
400:

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

432: , x_return_Status OUT NOCOPY VARCHAR2
433: )
434: IS
435: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
436: -- l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
437: l_return_status VARCHAR2(30) := '';
438: l_msg_count NUMBER := 0;
439: l_msg_data VARCHAR2(2000) := '';
440:

Line 473: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

469: AND resource_seq_num = p_eam_res_rec.resource_seq_num;
470:
471: x_return_status := l_return_status;
472: x_mesg_token_tbl := l_mesg_token_tbl;
473: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475: -- API is called to set the estimation_status
476: EAM_AutomaticEst.Auto_Reest_of_Cost(
477: p_wip_entity_id => p_eam_res_rec.wip_entity_id,

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

507: , x_return_status OUT NOCOPY VARCHAR2
508: )
509: IS
510: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
511: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
512: BEGIN
513:
514: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
515: THEN

Line 581: x_return_status := FND_API.G_RET_STS_SUCCESS;

577: I NUMBER;
578: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
579:
580: BEGIN
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: FOR I IN 1..p_eam_res_tbl.COUNT LOOP
584:
585: