APPS.EAM_OP_UTILITY_PVT dependencies on FND_API

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

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

Line 127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

123: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
124: x_eam_op_rec := l_eam_op_rec;
125:
126: WHEN OTHERS THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: x_eam_op_rec := l_eam_op_rec;
129:
130: END Query_Row;
131:

Line 157: x_return_status := fnd_api.g_ret_sts_error;

153: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing OP rec for ' || p_eam_op_rec.operation_seq_num); END IF;
154:
155: -- bug no 3444091
156: if p_eam_op_rec.start_date > p_eam_op_rec.completion_date then
157: x_return_status := fnd_api.g_ret_sts_error;
158: fnd_message.set_name('EAM','EAM_WO_OP_DT_ERR');
159: return;
160: end if;
161:

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

347: END IF;
348:
349: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new operation') ; END IF;
350:
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: EXCEPTION
354: WHEN OTHERS THEN
355: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
358: , x_mesg_token_Tbl => x_mesg_token_tbl
359: );
360:
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362:
363: END Insert_Row;
364:
365: /********************************************************************

Line 388: x_return_status := fnd_api.g_ret_sts_error;

384: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating OP '|| p_eam_op_rec.operation_seq_num); END IF;
385:
386: -- bug no 3444091
387: if p_eam_op_rec.start_date > p_eam_op_rec.completion_date then
388: x_return_status := fnd_api.g_ret_sts_error;
389: fnd_message.set_name('EAM','EAM_WO_OP_DT_ERR');
390: return;
391: end if;
392:

Line 457: x_return_status := FND_API.G_RET_STS_SUCCESS;

453: WHERE organization_id = p_eam_op_rec.organization_id
454: AND wip_entity_id = p_eam_op_rec.wip_entity_id
455: AND operation_seq_num = p_eam_op_rec.operation_seq_num ;
456: END IF;
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: END Update_Row;
460:
461:

Line 490: x_return_status := FND_API.G_RET_STS_SUCCESS;

486: AND organization_id = p_eam_op_rec.organization_id
487: AND operation_seq_num = p_eam_op_rec.operation_seq_num
488: AND (enable_flag = 'Y' OR enable_flag IS NULL);
489:
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: END Delete_Row;
493:
494:

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

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