[Home] [Help]
44: , x_Return_status OUT NOCOPY VARCHAR2
45: )
46: IS
47: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
48: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
49: l_dummy varchar2(10);
50: BEGIN
51:
52: SELECT
141: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
142: x_eam_mat_req_rec := l_eam_mat_req_rec;
143:
144: WHEN OTHERS THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: x_eam_mat_req_rec := l_eam_mat_req_rec;
147:
148: END Query_Row;
149:
325:
326:
327: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Material Requirements') ; END IF;
328:
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331: -- bug number 2251186
332: -- API is called to set the estimation_status
333: --added for 3658112.do not call for unplanned materials
355: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
356: , x_mesg_token_Tbl => x_mesg_token_tbl
357: );
358:
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360:
361: END Insert_Row;
362:
363: /********************************************************************
443: AND ( operation_seq_num = p_eam_mat_req_rec.operation_seq_num
444: OR operation_seq_num = 1 ) /* Added the check operation_seq_num = 1 so that op seq num can be changed if it is 1 */
445: AND inventory_item_id = p_eam_mat_req_rec.inventory_item_id;
446:
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448:
449: --added for 3658112.do not call for unplanned materials
450: IF(p_eam_mat_req_rec.released_quantity is null OR p_eam_mat_req_rec.released_quantity<>0) THEN
451: -- comparing new quantity with existing quantity
505: AND wip_entity_id = p_eam_mat_req_rec.wip_entity_id
506: AND operation_seq_num = p_eam_mat_req_rec.operation_seq_num
507: AND inventory_item_id = p_eam_mat_req_rec.inventory_item_id;
508:
509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510:
511: --added for 3658112.do not call for unplanned materials
512: IF(p_eam_mat_req_rec.released_quantity is null OR p_eam_mat_req_rec.released_quantity<>0) THEN
513: -- API is called to set the estimation_status
545: , x_return_status OUT NOCOPY VARCHAR2
546: )
547: IS
548: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
549: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
550: BEGIN
551:
552: IF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
553: THEN