[Home] [Help]
21: l_output_dir VARCHAR2(512);
22: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE;
23: l_out_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE;
24: l_token_tbl EAM_ERROR_MESSAGE_PVT.TOKEN_TBL_TYPE;
25: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26: BEGIN
27: p_debug := NVL(FND_PROFILE.VALUE('EAM_DEBUG'), 'N');
28: EAM_PROCESS_WO_PVT.SET_DEBUG(p_debug);
29:
28: EAM_PROCESS_WO_PVT.SET_DEBUG(p_debug);
29:
30: EAM_ERROR_MESSAGE_PVT.SET_BO_IDENTIFIER(p_bo_identifier => 'EAM');
31:
32: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
33: EAM_ERROR_MESSAGE_PVT.INITIALIZE;
34: END IF;
35:
36: EAM_WORKORDER_UTIL_PKG.LOG_PATH(l_output_dir);
74: p_mesg_token_tbl => l_mesg_token_tbl,
75: x_mesg_token_tbl => l_out_mesg_token_tbl);
76: l_mesg_token_tbl := l_out_mesg_token_tbl;
77:
78: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
79: p_debug:= 'N';
80: EAM_PROCESS_WO_PVT.SET_DEBUG(p_debug);
81: END IF;
82: END IF;
216: IF nvl(l_return_status,'S') <> 'S' THEN
217: -- Log error, but continue processing
218: l_return_status := 'E';
219: debug('Error in API - EXPLODE_CE_ACTIVITIES');
220: RAISE FND_API.G_EXC_ERROR;
221: END IF; -- nvl(l_return_status,'S') <> 'S'
222: debug('Completed API - EXPLODE_CE_ACTIVITIES');
223:
224: -- All the associated acitivites are exploeded and
227: -- EAM_CE_WORK_ORDER_LINES, but dont commit the data
228: debug('Calling API - INSERT_ALL_WO_LINES');
229: INSERT_ALL_WO_LINES(
230: p_api_version => 1.0
231: , p_init_msg_list => FND_API.G_FALSE
232: , p_commit => p_commit
233: , p_estimate_id => l_estimate_id
234: , p_eam_ce_wo_lines_tbl => l_out_eam_ce_wo_lines_tbl
235: , x_return_status => l_return_status
240: IF nvl(l_return_status,'S') <> 'S' THEN
241: -- Log error, but continue processing
242: l_return_status := 'E';
243: debug('Error in API - INSERT_ALL_WO_LINES');
244: RAISE FND_API.G_EXC_ERROR;
245: END IF; -- nvl(l_return_status,'S') <> 'S'
246: debug('Completed API - INSERT_ALL_WO_LINES');
247:
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
244: RAISE FND_API.G_EXC_ERROR;
245: END IF; -- nvl(l_return_status,'S') <> 'S'
246: debug('Completed API - INSERT_ALL_WO_LINES');
247:
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249: debug ('End EXPLODE_INITIAL_ESTIMATE');
250: --COMMIT;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249: debug ('End EXPLODE_INITIAL_ESTIMATE');
250: --COMMIT;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_INITIAL_ESTIMATE');
256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
250: --COMMIT;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_INITIAL_ESTIMATE');
256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
257: p_data => x_msg_data);
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_INITIAL_ESTIMATE');
256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
257: p_data => x_msg_data);
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_INITIAL_ESTIMATE');
256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
257: p_data => x_msg_data);
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - EXPLODE_INITIAL_ESTIMATE');
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
257: p_data => x_msg_data);
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - EXPLODE_INITIAL_ESTIMATE');
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
263: p_data => x_msg_data);
264: WHEN OTHERS THEN
257: p_data => x_msg_data);
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - EXPLODE_INITIAL_ESTIMATE');
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
263: p_data => x_msg_data);
264: WHEN OTHERS THEN
265: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
263: p_data => x_msg_data);
264: WHEN OTHERS THEN
265: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: debug('OTHERS Error in API - EXPLODE_INITIAL_ESTIMATE');
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_INITIAL_ESTIMATE');
270: END IF;
274: END EXPLODE_INITIAL_ESTIMATE;
275:
276: PROCEDURE DELETE_WO_LINE(
277: p_api_version IN NUMBER := 1.0
278: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
279: , p_commit IN VARCHAR2
280: , p_work_order_line_id IN NUMBER
281: , x_return_status OUT NOCOPY VARCHAR2
282: , x_msg_count OUT NOCOPY NUMBER
294: --FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
295: --FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
296: --FND_MESSAGE.SET_TOKEN('VALUE', p_parent_wo_line_rec.ORGANIZATION_ID);
297: --FND_MSG_PUB.ADD;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300:
301: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW(
302: p_work_order_line_id => p_work_order_line_id
309: x_return_status := 'S';
310: debug('End API - DELETE_WO_LINE');
311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: ROLLBACK TO DELETE_WO_LINE;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: debug('FND_API.G_EXC_ERROR Error in API - DELETE_WO_LINE');
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: ROLLBACK TO DELETE_WO_LINE;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: debug('FND_API.G_EXC_ERROR Error in API - DELETE_WO_LINE');
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
318: p_data => x_msg_data);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: ROLLBACK TO DELETE_WO_LINE;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: debug('FND_API.G_EXC_ERROR Error in API - DELETE_WO_LINE');
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
318: p_data => x_msg_data);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO DELETE_WO_LINE;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: debug('FND_API.G_EXC_ERROR Error in API - DELETE_WO_LINE');
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
318: p_data => x_msg_data);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO DELETE_WO_LINE;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - DELETE_WO_LINE');
323: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
318: p_data => x_msg_data);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO DELETE_WO_LINE;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - DELETE_WO_LINE');
323: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN OTHERS THEN
318: p_data => x_msg_data);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO DELETE_WO_LINE;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - DELETE_WO_LINE');
323: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN OTHERS THEN
326: ROLLBACK TO DELETE_WO_LINE;
323: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN OTHERS THEN
326: ROLLBACK TO DELETE_WO_LINE;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: debug('OTHERS Error in API - DELETE_WO_LINE');
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
330: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'DELETE_WO_LINE');
331: END IF;
334: END DELETE_WO_LINE;
335:
336: PROCEDURE INSERT_PARENT_WO_LINE(
337: p_api_version IN NUMBER := 1.0
338: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
339: , p_commit IN VARCHAR2
340: , p_estimate_id IN NUMBER
341: , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC
342: , x_return_status OUT NOCOPY VARCHAR2
389: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
390: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
391: FND_MESSAGE.SET_TOKEN('VALUE', p_parent_wo_line_rec.ORGANIZATION_ID);
392: FND_MSG_PUB.ADD;
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395:
396: IF (p_estimate_id IS NULL) THEN
397: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
397: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
398: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_NUMBER');
399: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_id);
400: FND_MSG_PUB.ADD;
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403:
404: -- If the parent details already exist, update the estimate
405: OPEN EST_PARENT_CSR;
411: -- and parent work order number
412: -- Construct estimate rec with the parent wo details
413: l_estimate_rec.ESTIMATE_ID := p_estimate_id;
414: l_estimate_rec.ORGANIZATION_ID := p_parent_wo_line_rec.ORGANIZATION_ID;
415: l_estimate_rec.ESTIMATE_NUMBER := FND_API.G_MISS_CHAR;
416: l_estimate_rec.ESTIMATE_DESCRIPTION := FND_API.G_MISS_CHAR;
417: l_estimate_rec.GROUPING_OPTION := FND_API.G_MISS_NUM;
418:
419: -- Bug 12541554
412: -- Construct estimate rec with the parent wo details
413: l_estimate_rec.ESTIMATE_ID := p_estimate_id;
414: l_estimate_rec.ORGANIZATION_ID := p_parent_wo_line_rec.ORGANIZATION_ID;
415: l_estimate_rec.ESTIMATE_NUMBER := FND_API.G_MISS_CHAR;
416: l_estimate_rec.ESTIMATE_DESCRIPTION := FND_API.G_MISS_CHAR;
417: l_estimate_rec.GROUPING_OPTION := FND_API.G_MISS_NUM;
418:
419: -- Bug 12541554
420: -- Get the system status from user defined status id
413: l_estimate_rec.ESTIMATE_ID := p_estimate_id;
414: l_estimate_rec.ORGANIZATION_ID := p_parent_wo_line_rec.ORGANIZATION_ID;
415: l_estimate_rec.ESTIMATE_NUMBER := FND_API.G_MISS_CHAR;
416: l_estimate_rec.ESTIMATE_DESCRIPTION := FND_API.G_MISS_CHAR;
417: l_estimate_rec.GROUPING_OPTION := FND_API.G_MISS_NUM;
418:
419: -- Bug 12541554
420: -- Get the system status from user defined status id
421: BEGIN
438: -- PARENT_WO_ID holds ESTIMATE_WORK_ORDER_LINE_ID
439: -- The the corresponding ESTIMATE_WORK_ORDER_LINE_ID contains all the
440: -- parent work order details
441: debug(' l_estimate_parent_rec.PARENT_WO_ID - ' || l_estimate_parent_rec.PARENT_WO_ID);
442: IF NVL(l_estimate_parent_rec.PARENT_WO_ID,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
443: AND NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') <> 'N' THEN
444:
445: l_wo_line_id_seq := l_estimate_parent_rec.PARENT_WO_ID;
446:
446:
447: debug(' Updating EAM_CE_WORK_ORDER_LINES_PKG Parent Work Order line - ' || l_wo_line_id_seq);
448: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
449: p_estimate_work_order_line_id => l_wo_line_id_seq
450: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
451: ,p_src_cu_id => FND_API.G_MISS_NUM
452: ,p_src_activity_id => FND_API.G_MISS_NUM
453: ,p_src_activity_qty => FND_API.G_MISS_NUM
454: ,p_src_op_seq_num => FND_API.G_MISS_NUM
447: debug(' Updating EAM_CE_WORK_ORDER_LINES_PKG Parent Work Order line - ' || l_wo_line_id_seq);
448: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
449: p_estimate_work_order_line_id => l_wo_line_id_seq
450: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
451: ,p_src_cu_id => FND_API.G_MISS_NUM
452: ,p_src_activity_id => FND_API.G_MISS_NUM
453: ,p_src_activity_qty => FND_API.G_MISS_NUM
454: ,p_src_op_seq_num => FND_API.G_MISS_NUM
455: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
448: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
449: p_estimate_work_order_line_id => l_wo_line_id_seq
450: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
451: ,p_src_cu_id => FND_API.G_MISS_NUM
452: ,p_src_activity_id => FND_API.G_MISS_NUM
453: ,p_src_activity_qty => FND_API.G_MISS_NUM
454: ,p_src_op_seq_num => FND_API.G_MISS_NUM
455: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
456: ,p_src_diff_id => FND_API.G_MISS_NUM
449: p_estimate_work_order_line_id => l_wo_line_id_seq
450: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
451: ,p_src_cu_id => FND_API.G_MISS_NUM
452: ,p_src_activity_id => FND_API.G_MISS_NUM
453: ,p_src_activity_qty => FND_API.G_MISS_NUM
454: ,p_src_op_seq_num => FND_API.G_MISS_NUM
455: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
456: ,p_src_diff_id => FND_API.G_MISS_NUM
457: ,p_diff_qty => FND_API.G_MISS_NUM
450: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
451: ,p_src_cu_id => FND_API.G_MISS_NUM
452: ,p_src_activity_id => FND_API.G_MISS_NUM
453: ,p_src_activity_qty => FND_API.G_MISS_NUM
454: ,p_src_op_seq_num => FND_API.G_MISS_NUM
455: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
456: ,p_src_diff_id => FND_API.G_MISS_NUM
457: ,p_diff_qty => FND_API.G_MISS_NUM
458: ,p_estimate_id => p_estimate_id
451: ,p_src_cu_id => FND_API.G_MISS_NUM
452: ,p_src_activity_id => FND_API.G_MISS_NUM
453: ,p_src_activity_qty => FND_API.G_MISS_NUM
454: ,p_src_op_seq_num => FND_API.G_MISS_NUM
455: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
456: ,p_src_diff_id => FND_API.G_MISS_NUM
457: ,p_diff_qty => FND_API.G_MISS_NUM
458: ,p_estimate_id => p_estimate_id
459: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
452: ,p_src_activity_id => FND_API.G_MISS_NUM
453: ,p_src_activity_qty => FND_API.G_MISS_NUM
454: ,p_src_op_seq_num => FND_API.G_MISS_NUM
455: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
456: ,p_src_diff_id => FND_API.G_MISS_NUM
457: ,p_diff_qty => FND_API.G_MISS_NUM
458: ,p_estimate_id => p_estimate_id
459: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
460: ,p_work_order_seq_num => FND_API.G_MISS_NUM
453: ,p_src_activity_qty => FND_API.G_MISS_NUM
454: ,p_src_op_seq_num => FND_API.G_MISS_NUM
455: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
456: ,p_src_diff_id => FND_API.G_MISS_NUM
457: ,p_diff_qty => FND_API.G_MISS_NUM
458: ,p_estimate_id => p_estimate_id
459: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
460: ,p_work_order_seq_num => FND_API.G_MISS_NUM
461: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
456: ,p_src_diff_id => FND_API.G_MISS_NUM
457: ,p_diff_qty => FND_API.G_MISS_NUM
458: ,p_estimate_id => p_estimate_id
459: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
460: ,p_work_order_seq_num => FND_API.G_MISS_NUM
461: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
462: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
463: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
464: ,p_primary_item_id => FND_API.G_MISS_NUM
459: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
460: ,p_work_order_seq_num => FND_API.G_MISS_NUM
461: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
462: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
463: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
464: ,p_primary_item_id => FND_API.G_MISS_NUM
465: ,p_status_type => l_system_status_rec.SYSTEM_STATUS -- Bug 12541554
466: --,p_status_type => FND_API.G_MISS_NUM
467: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
460: ,p_work_order_seq_num => FND_API.G_MISS_NUM
461: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
462: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
463: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
464: ,p_primary_item_id => FND_API.G_MISS_NUM
465: ,p_status_type => l_system_status_rec.SYSTEM_STATUS -- Bug 12541554
466: --,p_status_type => FND_API.G_MISS_NUM
467: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
468: ,p_scheduled_start_date => sysdate
462: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
463: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
464: ,p_primary_item_id => FND_API.G_MISS_NUM
465: ,p_status_type => l_system_status_rec.SYSTEM_STATUS -- Bug 12541554
466: --,p_status_type => FND_API.G_MISS_NUM
467: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
468: ,p_scheduled_start_date => sysdate
469: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
470: ,p_project_id => p_parent_wo_line_rec.PROJECT_ID
465: ,p_status_type => l_system_status_rec.SYSTEM_STATUS -- Bug 12541554
466: --,p_status_type => FND_API.G_MISS_NUM
467: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
468: ,p_scheduled_start_date => sysdate
469: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
470: ,p_project_id => p_parent_wo_line_rec.PROJECT_ID
471: ,p_task_id => p_parent_wo_line_rec.TASK_ID
472: ,p_maintenance_object_id => p_parent_wo_line_rec.MAINTENANCE_OBJECT_ID
473: ,p_maintenance_object_type => p_parent_wo_line_rec.MAINTENANCE_OBJECT_TYPE
473: ,p_maintenance_object_type => p_parent_wo_line_rec.MAINTENANCE_OBJECT_TYPE
474: ,p_maintenance_object_source => p_parent_wo_line_rec.MAINTENANCE_OBJECT_SOURCE
475: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
476: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
477: ,p_op_seq_num => FND_API.G_MISS_NUM
478: ,p_op_description => FND_API.G_MISS_CHAR
479: ,p_standard_operation_id => FND_API.G_MISS_NUM
480: ,p_op_department_id => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
474: ,p_maintenance_object_source => p_parent_wo_line_rec.MAINTENANCE_OBJECT_SOURCE
475: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
476: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
477: ,p_op_seq_num => FND_API.G_MISS_NUM
478: ,p_op_description => FND_API.G_MISS_CHAR
479: ,p_standard_operation_id => FND_API.G_MISS_NUM
480: ,p_op_department_id => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
482: ,p_res_seq_num => FND_API.G_MISS_NUM
475: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
476: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
477: ,p_op_seq_num => FND_API.G_MISS_NUM
478: ,p_op_description => FND_API.G_MISS_CHAR
479: ,p_standard_operation_id => FND_API.G_MISS_NUM
480: ,p_op_department_id => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
482: ,p_res_seq_num => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM
476: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
477: ,p_op_seq_num => FND_API.G_MISS_NUM
478: ,p_op_description => FND_API.G_MISS_CHAR
479: ,p_standard_operation_id => FND_API.G_MISS_NUM
480: ,p_op_department_id => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
482: ,p_res_seq_num => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM
484: ,p_res_uom => FND_API.G_MISS_CHAR
477: ,p_op_seq_num => FND_API.G_MISS_NUM
478: ,p_op_description => FND_API.G_MISS_CHAR
479: ,p_standard_operation_id => FND_API.G_MISS_NUM
480: ,p_op_department_id => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
482: ,p_res_seq_num => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM
484: ,p_res_uom => FND_API.G_MISS_CHAR
485: ,p_res_basis_type => FND_API.G_MISS_NUM
478: ,p_op_description => FND_API.G_MISS_CHAR
479: ,p_standard_operation_id => FND_API.G_MISS_NUM
480: ,p_op_department_id => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
482: ,p_res_seq_num => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM
484: ,p_res_uom => FND_API.G_MISS_CHAR
485: ,p_res_basis_type => FND_API.G_MISS_NUM
486: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
479: ,p_standard_operation_id => FND_API.G_MISS_NUM
480: ,p_op_department_id => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
482: ,p_res_seq_num => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM
484: ,p_res_uom => FND_API.G_MISS_CHAR
485: ,p_res_basis_type => FND_API.G_MISS_NUM
486: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
487: ,p_res_required_units => FND_API.G_MISS_NUM
480: ,p_op_department_id => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
482: ,p_res_seq_num => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM
484: ,p_res_uom => FND_API.G_MISS_CHAR
485: ,p_res_basis_type => FND_API.G_MISS_NUM
486: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
487: ,p_res_required_units => FND_API.G_MISS_NUM
488: ,p_res_assigned_units => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
482: ,p_res_seq_num => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM
484: ,p_res_uom => FND_API.G_MISS_CHAR
485: ,p_res_basis_type => FND_API.G_MISS_NUM
486: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
487: ,p_res_required_units => FND_API.G_MISS_NUM
488: ,p_res_assigned_units => FND_API.G_MISS_NUM
489: ,p_item_type => FND_API.G_MISS_NUM
482: ,p_res_seq_num => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM
484: ,p_res_uom => FND_API.G_MISS_CHAR
485: ,p_res_basis_type => FND_API.G_MISS_NUM
486: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
487: ,p_res_required_units => FND_API.G_MISS_NUM
488: ,p_res_assigned_units => FND_API.G_MISS_NUM
489: ,p_item_type => FND_API.G_MISS_NUM
490: ,p_required_quantity => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM
484: ,p_res_uom => FND_API.G_MISS_CHAR
485: ,p_res_basis_type => FND_API.G_MISS_NUM
486: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
487: ,p_res_required_units => FND_API.G_MISS_NUM
488: ,p_res_assigned_units => FND_API.G_MISS_NUM
489: ,p_item_type => FND_API.G_MISS_NUM
490: ,p_required_quantity => FND_API.G_MISS_NUM
491: ,p_unit_price => FND_API.G_MISS_NUM
484: ,p_res_uom => FND_API.G_MISS_CHAR
485: ,p_res_basis_type => FND_API.G_MISS_NUM
486: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
487: ,p_res_required_units => FND_API.G_MISS_NUM
488: ,p_res_assigned_units => FND_API.G_MISS_NUM
489: ,p_item_type => FND_API.G_MISS_NUM
490: ,p_required_quantity => FND_API.G_MISS_NUM
491: ,p_unit_price => FND_API.G_MISS_NUM
492: ,p_uom => FND_API.G_MISS_CHAR
485: ,p_res_basis_type => FND_API.G_MISS_NUM
486: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
487: ,p_res_required_units => FND_API.G_MISS_NUM
488: ,p_res_assigned_units => FND_API.G_MISS_NUM
489: ,p_item_type => FND_API.G_MISS_NUM
490: ,p_required_quantity => FND_API.G_MISS_NUM
491: ,p_unit_price => FND_API.G_MISS_NUM
492: ,p_uom => FND_API.G_MISS_CHAR
493: ,p_basis_type => FND_API.G_MISS_NUM
486: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
487: ,p_res_required_units => FND_API.G_MISS_NUM
488: ,p_res_assigned_units => FND_API.G_MISS_NUM
489: ,p_item_type => FND_API.G_MISS_NUM
490: ,p_required_quantity => FND_API.G_MISS_NUM
491: ,p_unit_price => FND_API.G_MISS_NUM
492: ,p_uom => FND_API.G_MISS_CHAR
493: ,p_basis_type => FND_API.G_MISS_NUM
494: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
487: ,p_res_required_units => FND_API.G_MISS_NUM
488: ,p_res_assigned_units => FND_API.G_MISS_NUM
489: ,p_item_type => FND_API.G_MISS_NUM
490: ,p_required_quantity => FND_API.G_MISS_NUM
491: ,p_unit_price => FND_API.G_MISS_NUM
492: ,p_uom => FND_API.G_MISS_CHAR
493: ,p_basis_type => FND_API.G_MISS_NUM
494: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
495: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
488: ,p_res_assigned_units => FND_API.G_MISS_NUM
489: ,p_item_type => FND_API.G_MISS_NUM
490: ,p_required_quantity => FND_API.G_MISS_NUM
491: ,p_unit_price => FND_API.G_MISS_NUM
492: ,p_uom => FND_API.G_MISS_CHAR
493: ,p_basis_type => FND_API.G_MISS_NUM
494: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
495: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
496: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
489: ,p_item_type => FND_API.G_MISS_NUM
490: ,p_required_quantity => FND_API.G_MISS_NUM
491: ,p_unit_price => FND_API.G_MISS_NUM
492: ,p_uom => FND_API.G_MISS_CHAR
493: ,p_basis_type => FND_API.G_MISS_NUM
494: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
495: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
496: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
497: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
490: ,p_required_quantity => FND_API.G_MISS_NUM
491: ,p_unit_price => FND_API.G_MISS_NUM
492: ,p_uom => FND_API.G_MISS_CHAR
493: ,p_basis_type => FND_API.G_MISS_NUM
494: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
495: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
496: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
497: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
498: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
491: ,p_unit_price => FND_API.G_MISS_NUM
492: ,p_uom => FND_API.G_MISS_CHAR
493: ,p_basis_type => FND_API.G_MISS_NUM
494: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
495: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
496: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
497: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
498: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
499: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
492: ,p_uom => FND_API.G_MISS_CHAR
493: ,p_basis_type => FND_API.G_MISS_NUM
494: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
495: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
496: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
497: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
498: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
499: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
500: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
493: ,p_basis_type => FND_API.G_MISS_NUM
494: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
495: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
496: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
497: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
498: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
499: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
500: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
501: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
494: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
495: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
496: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
497: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
498: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
499: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
500: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
501: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
502: ,p_di_amount => FND_API.G_MISS_NUM
495: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
496: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
497: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
498: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
499: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
500: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
501: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
502: ,p_di_amount => FND_API.G_MISS_NUM
503: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
496: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
497: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
498: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
499: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
500: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
501: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
502: ,p_di_amount => FND_API.G_MISS_NUM
503: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
504: ,p_di_description => FND_API.G_MISS_CHAR
497: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
498: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
499: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
500: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
501: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
502: ,p_di_amount => FND_API.G_MISS_NUM
503: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
504: ,p_di_description => FND_API.G_MISS_CHAR
505: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
498: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
499: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
500: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
501: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
502: ,p_di_amount => FND_API.G_MISS_NUM
503: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
504: ,p_di_description => FND_API.G_MISS_CHAR
505: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
506: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
499: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
500: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
501: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
502: ,p_di_amount => FND_API.G_MISS_NUM
503: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
504: ,p_di_description => FND_API.G_MISS_CHAR
505: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
506: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
507: ,p_di_need_by_date => FND_API.G_MISS_DATE
500: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
501: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
502: ,p_di_amount => FND_API.G_MISS_NUM
503: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
504: ,p_di_description => FND_API.G_MISS_CHAR
505: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
506: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
507: ,p_di_need_by_date => FND_API.G_MISS_DATE
508: ,p_work_order_line_cost => FND_API.G_MISS_NUM
501: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
502: ,p_di_amount => FND_API.G_MISS_NUM
503: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
504: ,p_di_description => FND_API.G_MISS_CHAR
505: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
506: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
507: ,p_di_need_by_date => FND_API.G_MISS_DATE
508: ,p_work_order_line_cost => FND_API.G_MISS_NUM
509: ,p_creation_date => sysdate
502: ,p_di_amount => FND_API.G_MISS_NUM
503: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
504: ,p_di_description => FND_API.G_MISS_CHAR
505: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
506: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
507: ,p_di_need_by_date => FND_API.G_MISS_DATE
508: ,p_work_order_line_cost => FND_API.G_MISS_NUM
509: ,p_creation_date => sysdate
510: ,p_created_by => FND_GLOBAL.LOGIN_ID
503: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
504: ,p_di_description => FND_API.G_MISS_CHAR
505: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
506: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
507: ,p_di_need_by_date => FND_API.G_MISS_DATE
508: ,p_work_order_line_cost => FND_API.G_MISS_NUM
509: ,p_creation_date => sysdate
510: ,p_created_by => FND_GLOBAL.LOGIN_ID
511: ,p_last_update_date => sysdate
504: ,p_di_description => FND_API.G_MISS_CHAR
505: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
506: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
507: ,p_di_need_by_date => FND_API.G_MISS_DATE
508: ,p_work_order_line_cost => FND_API.G_MISS_NUM
509: ,p_creation_date => sysdate
510: ,p_created_by => FND_GLOBAL.LOGIN_ID
511: ,p_last_update_date => sysdate
512: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
510: ,p_created_by => FND_GLOBAL.LOGIN_ID
511: ,p_last_update_date => sysdate
512: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
513: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
514: ,p_work_order_type => FND_API.G_MISS_NUM
515: ,p_activity_type => FND_API.G_MISS_NUM
516: ,p_activity_source => FND_API.G_MISS_NUM
517: ,p_activity_cause => FND_API.G_MISS_NUM
518: ,p_available_qty => FND_API.G_MISS_NUM
511: ,p_last_update_date => sysdate
512: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
513: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
514: ,p_work_order_type => FND_API.G_MISS_NUM
515: ,p_activity_type => FND_API.G_MISS_NUM
516: ,p_activity_source => FND_API.G_MISS_NUM
517: ,p_activity_cause => FND_API.G_MISS_NUM
518: ,p_available_qty => FND_API.G_MISS_NUM
519: ,p_item_comments => FND_API.G_MISS_CHAR
512: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
513: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
514: ,p_work_order_type => FND_API.G_MISS_NUM
515: ,p_activity_type => FND_API.G_MISS_NUM
516: ,p_activity_source => FND_API.G_MISS_NUM
517: ,p_activity_cause => FND_API.G_MISS_NUM
518: ,p_available_qty => FND_API.G_MISS_NUM
519: ,p_item_comments => FND_API.G_MISS_CHAR
520: ,p_cu_qty => FND_API.G_MISS_NUM
513: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
514: ,p_work_order_type => FND_API.G_MISS_NUM
515: ,p_activity_type => FND_API.G_MISS_NUM
516: ,p_activity_source => FND_API.G_MISS_NUM
517: ,p_activity_cause => FND_API.G_MISS_NUM
518: ,p_available_qty => FND_API.G_MISS_NUM
519: ,p_item_comments => FND_API.G_MISS_CHAR
520: ,p_cu_qty => FND_API.G_MISS_NUM
521: ,p_res_sch_flag => FND_API.G_MISS_NUM
514: ,p_work_order_type => FND_API.G_MISS_NUM
515: ,p_activity_type => FND_API.G_MISS_NUM
516: ,p_activity_source => FND_API.G_MISS_NUM
517: ,p_activity_cause => FND_API.G_MISS_NUM
518: ,p_available_qty => FND_API.G_MISS_NUM
519: ,p_item_comments => FND_API.G_MISS_CHAR
520: ,p_cu_qty => FND_API.G_MISS_NUM
521: ,p_res_sch_flag => FND_API.G_MISS_NUM
522: );
515: ,p_activity_type => FND_API.G_MISS_NUM
516: ,p_activity_source => FND_API.G_MISS_NUM
517: ,p_activity_cause => FND_API.G_MISS_NUM
518: ,p_available_qty => FND_API.G_MISS_NUM
519: ,p_item_comments => FND_API.G_MISS_CHAR
520: ,p_cu_qty => FND_API.G_MISS_NUM
521: ,p_res_sch_flag => FND_API.G_MISS_NUM
522: );
523:
516: ,p_activity_source => FND_API.G_MISS_NUM
517: ,p_activity_cause => FND_API.G_MISS_NUM
518: ,p_available_qty => FND_API.G_MISS_NUM
519: ,p_item_comments => FND_API.G_MISS_CHAR
520: ,p_cu_qty => FND_API.G_MISS_NUM
521: ,p_res_sch_flag => FND_API.G_MISS_NUM
522: );
523:
524: ELSE
517: ,p_activity_cause => FND_API.G_MISS_NUM
518: ,p_available_qty => FND_API.G_MISS_NUM
519: ,p_item_comments => FND_API.G_MISS_CHAR
520: ,p_cu_qty => FND_API.G_MISS_NUM
521: ,p_res_sch_flag => FND_API.G_MISS_NUM
522: );
523:
524: ELSE
525:
527: debug(' Generating new Parent Work order - ' || l_wo_line_id_seq);
528:
529: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
530: p_estimate_work_order_line_id => l_wo_line_id_seq
531: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
532: ,p_src_cu_id => FND_API.G_MISS_NUM
533: ,p_src_activity_id => FND_API.G_MISS_NUM
534: ,p_src_activity_qty => FND_API.G_MISS_NUM
535: ,p_src_op_seq_num => FND_API.G_MISS_NUM
528:
529: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
530: p_estimate_work_order_line_id => l_wo_line_id_seq
531: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
532: ,p_src_cu_id => FND_API.G_MISS_NUM
533: ,p_src_activity_id => FND_API.G_MISS_NUM
534: ,p_src_activity_qty => FND_API.G_MISS_NUM
535: ,p_src_op_seq_num => FND_API.G_MISS_NUM
536: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
529: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
530: p_estimate_work_order_line_id => l_wo_line_id_seq
531: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
532: ,p_src_cu_id => FND_API.G_MISS_NUM
533: ,p_src_activity_id => FND_API.G_MISS_NUM
534: ,p_src_activity_qty => FND_API.G_MISS_NUM
535: ,p_src_op_seq_num => FND_API.G_MISS_NUM
536: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
537: ,p_src_diff_id => FND_API.G_MISS_NUM
530: p_estimate_work_order_line_id => l_wo_line_id_seq
531: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
532: ,p_src_cu_id => FND_API.G_MISS_NUM
533: ,p_src_activity_id => FND_API.G_MISS_NUM
534: ,p_src_activity_qty => FND_API.G_MISS_NUM
535: ,p_src_op_seq_num => FND_API.G_MISS_NUM
536: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
537: ,p_src_diff_id => FND_API.G_MISS_NUM
538: ,p_diff_qty => FND_API.G_MISS_NUM
531: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
532: ,p_src_cu_id => FND_API.G_MISS_NUM
533: ,p_src_activity_id => FND_API.G_MISS_NUM
534: ,p_src_activity_qty => FND_API.G_MISS_NUM
535: ,p_src_op_seq_num => FND_API.G_MISS_NUM
536: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
537: ,p_src_diff_id => FND_API.G_MISS_NUM
538: ,p_diff_qty => FND_API.G_MISS_NUM
539: ,p_estimate_id => p_estimate_id
532: ,p_src_cu_id => FND_API.G_MISS_NUM
533: ,p_src_activity_id => FND_API.G_MISS_NUM
534: ,p_src_activity_qty => FND_API.G_MISS_NUM
535: ,p_src_op_seq_num => FND_API.G_MISS_NUM
536: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
537: ,p_src_diff_id => FND_API.G_MISS_NUM
538: ,p_diff_qty => FND_API.G_MISS_NUM
539: ,p_estimate_id => p_estimate_id
540: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
533: ,p_src_activity_id => FND_API.G_MISS_NUM
534: ,p_src_activity_qty => FND_API.G_MISS_NUM
535: ,p_src_op_seq_num => FND_API.G_MISS_NUM
536: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
537: ,p_src_diff_id => FND_API.G_MISS_NUM
538: ,p_diff_qty => FND_API.G_MISS_NUM
539: ,p_estimate_id => p_estimate_id
540: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
541: ,p_work_order_seq_num => FND_API.G_MISS_NUM
534: ,p_src_activity_qty => FND_API.G_MISS_NUM
535: ,p_src_op_seq_num => FND_API.G_MISS_NUM
536: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
537: ,p_src_diff_id => FND_API.G_MISS_NUM
538: ,p_diff_qty => FND_API.G_MISS_NUM
539: ,p_estimate_id => p_estimate_id
540: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
541: ,p_work_order_seq_num => FND_API.G_MISS_NUM
542: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
537: ,p_src_diff_id => FND_API.G_MISS_NUM
538: ,p_diff_qty => FND_API.G_MISS_NUM
539: ,p_estimate_id => p_estimate_id
540: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
541: ,p_work_order_seq_num => FND_API.G_MISS_NUM
542: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
543: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
544: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
545: ,p_primary_item_id => FND_API.G_MISS_NUM
540: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
541: ,p_work_order_seq_num => FND_API.G_MISS_NUM
542: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
543: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
544: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
545: ,p_primary_item_id => FND_API.G_MISS_NUM
546: ,p_status_type => l_system_status_rec.SYSTEM_STATUS -- Bug 12541554
547: --,p_status_type => FND_API.G_MISS_NUM
548: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
541: ,p_work_order_seq_num => FND_API.G_MISS_NUM
542: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
543: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
544: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
545: ,p_primary_item_id => FND_API.G_MISS_NUM
546: ,p_status_type => l_system_status_rec.SYSTEM_STATUS -- Bug 12541554
547: --,p_status_type => FND_API.G_MISS_NUM
548: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
549: ,p_scheduled_start_date => sysdate
543: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
544: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
545: ,p_primary_item_id => FND_API.G_MISS_NUM
546: ,p_status_type => l_system_status_rec.SYSTEM_STATUS -- Bug 12541554
547: --,p_status_type => FND_API.G_MISS_NUM
548: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
549: ,p_scheduled_start_date => sysdate
550: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
551: ,p_project_id => p_parent_wo_line_rec.PROJECT_ID
546: ,p_status_type => l_system_status_rec.SYSTEM_STATUS -- Bug 12541554
547: --,p_status_type => FND_API.G_MISS_NUM
548: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
549: ,p_scheduled_start_date => sysdate
550: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
551: ,p_project_id => p_parent_wo_line_rec.PROJECT_ID
552: ,p_task_id => p_parent_wo_line_rec.TASK_ID
553: ,p_maintenance_object_id => p_parent_wo_line_rec.MAINTENANCE_OBJECT_ID
554: ,p_maintenance_object_type => p_parent_wo_line_rec.MAINTENANCE_OBJECT_TYPE
554: ,p_maintenance_object_type => p_parent_wo_line_rec.MAINTENANCE_OBJECT_TYPE
555: ,p_maintenance_object_source => p_parent_wo_line_rec.MAINTENANCE_OBJECT_SOURCE
556: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
557: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
558: ,p_op_seq_num => FND_API.G_MISS_NUM
559: ,p_op_description => FND_API.G_MISS_CHAR
560: ,p_standard_operation_id => FND_API.G_MISS_NUM
561: ,p_op_department_id => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
555: ,p_maintenance_object_source => p_parent_wo_line_rec.MAINTENANCE_OBJECT_SOURCE
556: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
557: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
558: ,p_op_seq_num => FND_API.G_MISS_NUM
559: ,p_op_description => FND_API.G_MISS_CHAR
560: ,p_standard_operation_id => FND_API.G_MISS_NUM
561: ,p_op_department_id => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
563: ,p_res_seq_num => FND_API.G_MISS_NUM
556: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
557: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
558: ,p_op_seq_num => FND_API.G_MISS_NUM
559: ,p_op_description => FND_API.G_MISS_CHAR
560: ,p_standard_operation_id => FND_API.G_MISS_NUM
561: ,p_op_department_id => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
563: ,p_res_seq_num => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM
557: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
558: ,p_op_seq_num => FND_API.G_MISS_NUM
559: ,p_op_description => FND_API.G_MISS_CHAR
560: ,p_standard_operation_id => FND_API.G_MISS_NUM
561: ,p_op_department_id => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
563: ,p_res_seq_num => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM
565: ,p_res_uom => FND_API.G_MISS_CHAR
558: ,p_op_seq_num => FND_API.G_MISS_NUM
559: ,p_op_description => FND_API.G_MISS_CHAR
560: ,p_standard_operation_id => FND_API.G_MISS_NUM
561: ,p_op_department_id => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
563: ,p_res_seq_num => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM
565: ,p_res_uom => FND_API.G_MISS_CHAR
566: ,p_res_basis_type => FND_API.G_MISS_NUM
559: ,p_op_description => FND_API.G_MISS_CHAR
560: ,p_standard_operation_id => FND_API.G_MISS_NUM
561: ,p_op_department_id => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
563: ,p_res_seq_num => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM
565: ,p_res_uom => FND_API.G_MISS_CHAR
566: ,p_res_basis_type => FND_API.G_MISS_NUM
567: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
560: ,p_standard_operation_id => FND_API.G_MISS_NUM
561: ,p_op_department_id => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
563: ,p_res_seq_num => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM
565: ,p_res_uom => FND_API.G_MISS_CHAR
566: ,p_res_basis_type => FND_API.G_MISS_NUM
567: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
568: ,p_res_required_units => FND_API.G_MISS_NUM
561: ,p_op_department_id => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
563: ,p_res_seq_num => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM
565: ,p_res_uom => FND_API.G_MISS_CHAR
566: ,p_res_basis_type => FND_API.G_MISS_NUM
567: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
568: ,p_res_required_units => FND_API.G_MISS_NUM
569: ,p_res_assigned_units => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
563: ,p_res_seq_num => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM
565: ,p_res_uom => FND_API.G_MISS_CHAR
566: ,p_res_basis_type => FND_API.G_MISS_NUM
567: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
568: ,p_res_required_units => FND_API.G_MISS_NUM
569: ,p_res_assigned_units => FND_API.G_MISS_NUM
570: ,p_item_type => FND_API.G_MISS_NUM
563: ,p_res_seq_num => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM
565: ,p_res_uom => FND_API.G_MISS_CHAR
566: ,p_res_basis_type => FND_API.G_MISS_NUM
567: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
568: ,p_res_required_units => FND_API.G_MISS_NUM
569: ,p_res_assigned_units => FND_API.G_MISS_NUM
570: ,p_item_type => FND_API.G_MISS_NUM
571: ,p_required_quantity => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM
565: ,p_res_uom => FND_API.G_MISS_CHAR
566: ,p_res_basis_type => FND_API.G_MISS_NUM
567: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
568: ,p_res_required_units => FND_API.G_MISS_NUM
569: ,p_res_assigned_units => FND_API.G_MISS_NUM
570: ,p_item_type => FND_API.G_MISS_NUM
571: ,p_required_quantity => FND_API.G_MISS_NUM
572: ,p_unit_price => FND_API.G_MISS_NUM
565: ,p_res_uom => FND_API.G_MISS_CHAR
566: ,p_res_basis_type => FND_API.G_MISS_NUM
567: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
568: ,p_res_required_units => FND_API.G_MISS_NUM
569: ,p_res_assigned_units => FND_API.G_MISS_NUM
570: ,p_item_type => FND_API.G_MISS_NUM
571: ,p_required_quantity => FND_API.G_MISS_NUM
572: ,p_unit_price => FND_API.G_MISS_NUM
573: ,p_uom => FND_API.G_MISS_CHAR
566: ,p_res_basis_type => FND_API.G_MISS_NUM
567: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
568: ,p_res_required_units => FND_API.G_MISS_NUM
569: ,p_res_assigned_units => FND_API.G_MISS_NUM
570: ,p_item_type => FND_API.G_MISS_NUM
571: ,p_required_quantity => FND_API.G_MISS_NUM
572: ,p_unit_price => FND_API.G_MISS_NUM
573: ,p_uom => FND_API.G_MISS_CHAR
574: ,p_basis_type => FND_API.G_MISS_NUM
567: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
568: ,p_res_required_units => FND_API.G_MISS_NUM
569: ,p_res_assigned_units => FND_API.G_MISS_NUM
570: ,p_item_type => FND_API.G_MISS_NUM
571: ,p_required_quantity => FND_API.G_MISS_NUM
572: ,p_unit_price => FND_API.G_MISS_NUM
573: ,p_uom => FND_API.G_MISS_CHAR
574: ,p_basis_type => FND_API.G_MISS_NUM
575: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
568: ,p_res_required_units => FND_API.G_MISS_NUM
569: ,p_res_assigned_units => FND_API.G_MISS_NUM
570: ,p_item_type => FND_API.G_MISS_NUM
571: ,p_required_quantity => FND_API.G_MISS_NUM
572: ,p_unit_price => FND_API.G_MISS_NUM
573: ,p_uom => FND_API.G_MISS_CHAR
574: ,p_basis_type => FND_API.G_MISS_NUM
575: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
576: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
569: ,p_res_assigned_units => FND_API.G_MISS_NUM
570: ,p_item_type => FND_API.G_MISS_NUM
571: ,p_required_quantity => FND_API.G_MISS_NUM
572: ,p_unit_price => FND_API.G_MISS_NUM
573: ,p_uom => FND_API.G_MISS_CHAR
574: ,p_basis_type => FND_API.G_MISS_NUM
575: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
576: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
577: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
570: ,p_item_type => FND_API.G_MISS_NUM
571: ,p_required_quantity => FND_API.G_MISS_NUM
572: ,p_unit_price => FND_API.G_MISS_NUM
573: ,p_uom => FND_API.G_MISS_CHAR
574: ,p_basis_type => FND_API.G_MISS_NUM
575: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
576: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
577: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
578: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
571: ,p_required_quantity => FND_API.G_MISS_NUM
572: ,p_unit_price => FND_API.G_MISS_NUM
573: ,p_uom => FND_API.G_MISS_CHAR
574: ,p_basis_type => FND_API.G_MISS_NUM
575: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
576: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
577: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
578: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
579: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
572: ,p_unit_price => FND_API.G_MISS_NUM
573: ,p_uom => FND_API.G_MISS_CHAR
574: ,p_basis_type => FND_API.G_MISS_NUM
575: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
576: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
577: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
578: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
579: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
580: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
573: ,p_uom => FND_API.G_MISS_CHAR
574: ,p_basis_type => FND_API.G_MISS_NUM
575: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
576: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
577: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
578: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
579: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
580: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
581: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
574: ,p_basis_type => FND_API.G_MISS_NUM
575: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
576: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
577: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
578: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
579: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
580: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
581: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
582: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
575: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
576: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
577: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
578: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
579: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
580: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
581: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
582: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
583: ,p_di_amount => FND_API.G_MISS_NUM
576: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
577: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
578: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
579: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
580: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
581: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
582: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
583: ,p_di_amount => FND_API.G_MISS_NUM
584: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
577: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
578: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
579: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
580: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
581: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
582: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
583: ,p_di_amount => FND_API.G_MISS_NUM
584: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
585: ,p_di_description => FND_API.G_MISS_CHAR
578: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
579: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
580: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
581: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
582: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
583: ,p_di_amount => FND_API.G_MISS_NUM
584: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
585: ,p_di_description => FND_API.G_MISS_CHAR
586: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
579: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
580: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
581: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
582: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
583: ,p_di_amount => FND_API.G_MISS_NUM
584: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
585: ,p_di_description => FND_API.G_MISS_CHAR
586: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
587: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
580: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
581: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
582: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
583: ,p_di_amount => FND_API.G_MISS_NUM
584: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
585: ,p_di_description => FND_API.G_MISS_CHAR
586: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
587: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
588: ,p_di_need_by_date => FND_API.G_MISS_DATE
581: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
582: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
583: ,p_di_amount => FND_API.G_MISS_NUM
584: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
585: ,p_di_description => FND_API.G_MISS_CHAR
586: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
587: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
588: ,p_di_need_by_date => FND_API.G_MISS_DATE
589: ,p_work_order_line_cost => FND_API.G_MISS_NUM
582: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
583: ,p_di_amount => FND_API.G_MISS_NUM
584: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
585: ,p_di_description => FND_API.G_MISS_CHAR
586: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
587: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
588: ,p_di_need_by_date => FND_API.G_MISS_DATE
589: ,p_work_order_line_cost => FND_API.G_MISS_NUM
590: ,p_creation_date => sysdate
583: ,p_di_amount => FND_API.G_MISS_NUM
584: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
585: ,p_di_description => FND_API.G_MISS_CHAR
586: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
587: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
588: ,p_di_need_by_date => FND_API.G_MISS_DATE
589: ,p_work_order_line_cost => FND_API.G_MISS_NUM
590: ,p_creation_date => sysdate
591: ,p_created_by => FND_GLOBAL.LOGIN_ID
584: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
585: ,p_di_description => FND_API.G_MISS_CHAR
586: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
587: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
588: ,p_di_need_by_date => FND_API.G_MISS_DATE
589: ,p_work_order_line_cost => FND_API.G_MISS_NUM
590: ,p_creation_date => sysdate
591: ,p_created_by => FND_GLOBAL.LOGIN_ID
592: ,p_last_update_date => sysdate
585: ,p_di_description => FND_API.G_MISS_CHAR
586: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
587: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
588: ,p_di_need_by_date => FND_API.G_MISS_DATE
589: ,p_work_order_line_cost => FND_API.G_MISS_NUM
590: ,p_creation_date => sysdate
591: ,p_created_by => FND_GLOBAL.LOGIN_ID
592: ,p_last_update_date => sysdate
593: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
591: ,p_created_by => FND_GLOBAL.LOGIN_ID
592: ,p_last_update_date => sysdate
593: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
594: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
595: ,p_work_order_type => FND_API.G_MISS_NUM
596: ,p_activity_type => FND_API.G_MISS_NUM
597: ,p_activity_source => FND_API.G_MISS_NUM
598: ,p_activity_cause => FND_API.G_MISS_NUM
599: ,p_available_qty => FND_API.G_MISS_NUM
592: ,p_last_update_date => sysdate
593: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
594: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
595: ,p_work_order_type => FND_API.G_MISS_NUM
596: ,p_activity_type => FND_API.G_MISS_NUM
597: ,p_activity_source => FND_API.G_MISS_NUM
598: ,p_activity_cause => FND_API.G_MISS_NUM
599: ,p_available_qty => FND_API.G_MISS_NUM
600: ,p_item_comments => FND_API.G_MISS_CHAR
593: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
594: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
595: ,p_work_order_type => FND_API.G_MISS_NUM
596: ,p_activity_type => FND_API.G_MISS_NUM
597: ,p_activity_source => FND_API.G_MISS_NUM
598: ,p_activity_cause => FND_API.G_MISS_NUM
599: ,p_available_qty => FND_API.G_MISS_NUM
600: ,p_item_comments => FND_API.G_MISS_CHAR
601: ,p_cu_qty => FND_API.G_MISS_NUM
594: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
595: ,p_work_order_type => FND_API.G_MISS_NUM
596: ,p_activity_type => FND_API.G_MISS_NUM
597: ,p_activity_source => FND_API.G_MISS_NUM
598: ,p_activity_cause => FND_API.G_MISS_NUM
599: ,p_available_qty => FND_API.G_MISS_NUM
600: ,p_item_comments => FND_API.G_MISS_CHAR
601: ,p_cu_qty => FND_API.G_MISS_NUM
602: ,p_res_sch_flag => FND_API.G_MISS_NUM
595: ,p_work_order_type => FND_API.G_MISS_NUM
596: ,p_activity_type => FND_API.G_MISS_NUM
597: ,p_activity_source => FND_API.G_MISS_NUM
598: ,p_activity_cause => FND_API.G_MISS_NUM
599: ,p_available_qty => FND_API.G_MISS_NUM
600: ,p_item_comments => FND_API.G_MISS_CHAR
601: ,p_cu_qty => FND_API.G_MISS_NUM
602: ,p_res_sch_flag => FND_API.G_MISS_NUM
603: );
596: ,p_activity_type => FND_API.G_MISS_NUM
597: ,p_activity_source => FND_API.G_MISS_NUM
598: ,p_activity_cause => FND_API.G_MISS_NUM
599: ,p_available_qty => FND_API.G_MISS_NUM
600: ,p_item_comments => FND_API.G_MISS_CHAR
601: ,p_cu_qty => FND_API.G_MISS_NUM
602: ,p_res_sch_flag => FND_API.G_MISS_NUM
603: );
604:
597: ,p_activity_source => FND_API.G_MISS_NUM
598: ,p_activity_cause => FND_API.G_MISS_NUM
599: ,p_available_qty => FND_API.G_MISS_NUM
600: ,p_item_comments => FND_API.G_MISS_CHAR
601: ,p_cu_qty => FND_API.G_MISS_NUM
602: ,p_res_sch_flag => FND_API.G_MISS_NUM
603: );
604:
605:
598: ,p_activity_cause => FND_API.G_MISS_NUM
599: ,p_available_qty => FND_API.G_MISS_NUM
600: ,p_item_comments => FND_API.G_MISS_CHAR
601: ,p_cu_qty => FND_API.G_MISS_NUM
602: ,p_res_sch_flag => FND_API.G_MISS_NUM
603: );
604:
605:
606: END IF; -- IF l_estimate_parent_rec.PARENT_WO_ID IS NULL THEN
641: );
642:
643: ELSE
644:
645: IF nvl(p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
646: -- p_parent_wo_line_rec.CREATE_PARENT_FLAG is 'N' the PARENT_WORK_ORDER_NUMBER is
647: -- existing wip entity id
648: -- Update the estimates table with the wip entity id (PARENT_WORK_ORDER_NUMBER)
649: -- of the existing work order
685:
686: -- If the create work order flag has been switched from Y to N
687: -- then delete the work order line created when the flag was Y
688: IF NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
689: NVL(l_estimate_parent_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
690:
691: debug(' Create parent work order flag flipped. Deleting existing work order line');
692: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (
693: p_work_order_line_id => l_estimate_parent_rec.PARENT_WO_ID
728: p_ATTRIBUTE15 => l_estimate_rec.attribute15
729: );
730:
731: IF NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
732: NVL(l_estimate_parent_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
733: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (
734: p_work_order_line_id => l_estimate_parent_rec.PARENT_WO_ID
735: );
736: END IF;
742: END IF;
743: debug('End API - INSERT_PARENT_WO_LINE');
744: x_return_status := 'S';
745: EXCEPTION
746: WHEN FND_API.G_EXC_ERROR THEN
747: ROLLBACK TO INSERT_PARENT_WO_LINE;
748: debug('FND_API.G_EXC_ERROR Error in API - INSERT_PARENT_WO_LINE');
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
744: x_return_status := 'S';
745: EXCEPTION
746: WHEN FND_API.G_EXC_ERROR THEN
747: ROLLBACK TO INSERT_PARENT_WO_LINE;
748: debug('FND_API.G_EXC_ERROR Error in API - INSERT_PARENT_WO_LINE');
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
751: p_data => x_msg_data);
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: EXCEPTION
746: WHEN FND_API.G_EXC_ERROR THEN
747: ROLLBACK TO INSERT_PARENT_WO_LINE;
748: debug('FND_API.G_EXC_ERROR Error in API - INSERT_PARENT_WO_LINE');
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
751: p_data => x_msg_data);
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: ROLLBACK TO INSERT_PARENT_WO_LINE;
748: debug('FND_API.G_EXC_ERROR Error in API - INSERT_PARENT_WO_LINE');
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
751: p_data => x_msg_data);
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: ROLLBACK TO INSERT_PARENT_WO_LINE;
754: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
751: p_data => x_msg_data);
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: ROLLBACK TO INSERT_PARENT_WO_LINE;
754: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
757: p_data => x_msg_data);
758: WHEN OTHERS THEN
751: p_data => x_msg_data);
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: ROLLBACK TO INSERT_PARENT_WO_LINE;
754: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
757: p_data => x_msg_data);
758: WHEN OTHERS THEN
759: ROLLBACK TO INSERT_PARENT_WO_LINE;
756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
757: p_data => x_msg_data);
758: WHEN OTHERS THEN
759: ROLLBACK TO INSERT_PARENT_WO_LINE;
760: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
763: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_PARENT_WO_LINE');
764: END IF;
757: p_data => x_msg_data);
758: WHEN OTHERS THEN
759: ROLLBACK TO INSERT_PARENT_WO_LINE;
760: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
763: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_PARENT_WO_LINE');
764: END IF;
765: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
864: debug(' l_ext_precision - ' || l_ext_precision );
865:
866: FOR std_op_rec IN STD_OP_RES_CUR LOOP
867:
868: IF NVL(std_op_rec.RESOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
869: -- Calculate Cost
870: debug(' Getting unit resource cost for std_op_rec.RESOURCE_ID - ' || std_op_rec.RESOURCE_ID );
871: GET_UNIT_RESOURCE_COST(
872: p_resource_id => std_op_rec.RESOURCE_ID
880:
881: IF nvl(x_return_status,'S') <> 'S' THEN
882: -- Log error, but continue processing
883: x_return_status := 'E';
884: RAISE FND_API.G_EXC_ERROR;
885: END IF; -- nvl(l_return_status,'S') <> 'S'
886: END IF;
887:
888: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
889: -- to insert wo line row
890:
891: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
892: p_estimate_work_order_line_id => NULL
893: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
894: ,p_src_cu_id => NULL
895: ,p_src_activity_id => NULL
896: ,p_src_activity_qty => NULL
897: ,p_src_op_seq_num => NULL
966: END LOOP; -- FOR std_op_rec IN STD_OP_RES_CUR LOOP
967: debug('End of API - EXPLODE_STD_OP');
968: x_return_status := 'S';
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: --ROLLBACK TO EXPLODE_STD_OP;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_STD_OP');
974: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
968: x_return_status := 'S';
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: --ROLLBACK TO EXPLODE_STD_OP;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_STD_OP');
974: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
975: p_data => x_msg_data);
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: --ROLLBACK TO EXPLODE_STD_OP;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_STD_OP');
974: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
975: p_data => x_msg_data);
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: -- ROLLBACK TO EXPLODE_STD_OP;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_STD_OP');
974: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
975: p_data => x_msg_data);
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: -- ROLLBACK TO EXPLODE_STD_OP;
978: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - EXPLODE_STD_OP');
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
974: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
975: p_data => x_msg_data);
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: -- ROLLBACK TO EXPLODE_STD_OP;
978: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - EXPLODE_STD_OP');
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
981: p_data => x_msg_data);
982: WHEN OTHERS THEN
975: p_data => x_msg_data);
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: -- ROLLBACK TO EXPLODE_STD_OP;
978: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - EXPLODE_STD_OP');
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
981: p_data => x_msg_data);
982: WHEN OTHERS THEN
983: -- ROLLBACK TO EXPLODE_STD_OP;
981: p_data => x_msg_data);
982: WHEN OTHERS THEN
983: -- ROLLBACK TO EXPLODE_STD_OP;
984: debug('OTHERS Error in API - EXPLODE_STD_OP');
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_STD_OP');
988: END IF;
989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
992:
993:
994: PROCEDURE INSERT_ALL_WO_LINES(
995: p_api_version IN NUMBER := 1.0
996: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
997: , p_commit IN VARCHAR2
998: , p_estimate_id IN NUMBER
999: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
1000: , x_return_status OUT NOCOPY VARCHAR2
1098: IF p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID IS NOT NULL THEN
1099:
1100: -- debug(' Update Work Order line - ' || p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID);
1101: -- If the resource is modified the cost needs to be calcuated again
1102: IF NVL(p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1103: -- Calculate Cost
1104: GET_UNIT_RESOURCE_COST(
1105: p_resource_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID
1106: , p_cost_type_id => l_cost_type_id
1112:
1113: IF nvl(l_return_status,'S') <> 'S' THEN
1114: -- Log error, but continue processing
1115: x_return_status := 'E';
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF; -- nvl(l_return_status,'S') <> 'S'
1118: END IF;
1119:
1120: -- Get the system status from user defined status id
1129:
1130: -- Call UPDATE_ROW TO update the changes
1131: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
1132: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID
1133: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
1134: ,p_src_cu_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_CU_ID
1135: ,p_src_activity_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_ID
1136: ,p_src_activity_qty => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_QTY
1137: ,p_src_op_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_OP_SEQ_NUM
1209: -- Assigning unit cost before recalculating
1210: l_unit_cost := p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_LINE_COST;
1211:
1212: -- If the resource is modified the cost needs to be calcuated again
1213: IF NVL(p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1214: -- Calculate Cost
1215: GET_UNIT_RESOURCE_COST(
1216: p_resource_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID
1217: , p_cost_type_id => l_cost_type_id
1223:
1224: IF nvl(l_return_status,'S') <> 'S' THEN
1225: -- Log error, but continue processing
1226: x_return_status := 'E';
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF; -- nvl(l_return_status,'S') <> 'S'
1229: END IF;
1230:
1231: -- Get the system status from user defined status id
1242: -- to insert wo line row
1243:
1244: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
1245: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID
1246: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
1247: ,p_src_cu_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_CU_ID
1248: ,p_src_activity_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_ID
1249: ,p_src_activity_qty => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_QTY
1250: ,p_src_op_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_OP_SEQ_NUM
1326: END IF;
1327: debug('End of API - INSERT_ALL_WO_LINES');
1328: x_return_status := 'S';
1329: EXCEPTION
1330: WHEN FND_API.G_EXC_ERROR THEN
1331: ROLLBACK TO INSERT_ALL_WO_LINES;
1332: debug('FND_API.G_EXC_ERROR Error in API INSERT_ALL_WO_LINES');
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1328: x_return_status := 'S';
1329: EXCEPTION
1330: WHEN FND_API.G_EXC_ERROR THEN
1331: ROLLBACK TO INSERT_ALL_WO_LINES;
1332: debug('FND_API.G_EXC_ERROR Error in API INSERT_ALL_WO_LINES');
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1335: p_data => x_msg_data);
1336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1329: EXCEPTION
1330: WHEN FND_API.G_EXC_ERROR THEN
1331: ROLLBACK TO INSERT_ALL_WO_LINES;
1332: debug('FND_API.G_EXC_ERROR Error in API INSERT_ALL_WO_LINES');
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1335: p_data => x_msg_data);
1336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1337: ROLLBACK TO INSERT_ALL_WO_LINES;
1332: debug('FND_API.G_EXC_ERROR Error in API INSERT_ALL_WO_LINES');
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1335: p_data => x_msg_data);
1336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1337: ROLLBACK TO INSERT_ALL_WO_LINES;
1338: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API INSERT_ALL_WO_LINES');
1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1335: p_data => x_msg_data);
1336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1337: ROLLBACK TO INSERT_ALL_WO_LINES;
1338: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API INSERT_ALL_WO_LINES');
1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1341: p_data => x_msg_data);
1342: WHEN OTHERS THEN
1335: p_data => x_msg_data);
1336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1337: ROLLBACK TO INSERT_ALL_WO_LINES;
1338: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API INSERT_ALL_WO_LINES');
1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1341: p_data => x_msg_data);
1342: WHEN OTHERS THEN
1343: ROLLBACK TO INSERT_ALL_WO_LINES;
1340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1341: p_data => x_msg_data);
1342: WHEN OTHERS THEN
1343: ROLLBACK TO INSERT_ALL_WO_LINES;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: debug('OTHERS Error in API INSERT_ALL_WO_LINES');
1346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1347: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_ALL_WO_LINES');
1348: END IF;
1402: WHERE ESTIMATE_ID = p_estimate_id;
1403:
1404: BEGIN
1405: INIT_DEBUG(
1406: p_init_msg_list => FND_API.G_TRUE,
1407: p_debug_filename => l_debug_filename,
1408: p_debug_file_mode => 'w',
1409: p_debug => l_debug);
1410:
1446: l_eam_mat_req_tbl := INIT_EAM_MAT_REQ_TBL_TYPE;
1447:
1448: -- Calling EAM_EXPLODE_ACTIVITY_PVT.EXPLODE_ACTIVITY to explode the activities
1449: EAM_EXPLODE_ACTIVITY_PVT.EXPLODE_ACTIVITY
1450: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL
1451: , p_eam_wo_rec => l_eam_wo_rec
1452: , p_eam_op_tbl => l_eam_op_tbl
1453: , p_eam_op_network_tbl => l_eam_op_network_tbl
1454: , p_eam_res_tbl => l_eam_res_tbl
1704:
1705: IF nvl(l_return_status,'S') <> 'S' THEN
1706: -- Log error, but continue processing
1707: x_return_status := 'E';
1708: RAISE FND_API.G_EXC_ERROR;
1709: END IF; -- nvl(l_return_status,'S') <> 'S'
1710:
1711: --l_wo_ind := l_wo_ind + 1;
1712: END IF; -- p_eam_res_tbl(l_res_index).OPERATION_SEQ_NUM = p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM
1822:
1823: IF nvl(l_return_status,'S') <> 'S' THEN
1824: -- Log error, but continue processing
1825: x_return_status := 'E';
1826: RAISE FND_API.G_EXC_ERROR;
1827: END IF; -- nvl(l_return_status,'S') <> 'S'
1828:
1829: --l_wo_ind := l_wo_ind + 1;
1830: END IF; --p_eam_mat_req_tbl(l_mat_index).OPERATION_SEQ_NUM = p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM
1873: x_eam_ce_wo_lines_tbl := l_eam_ce_wo_lines_tbl;
1874: debug('End of API - POPULATE_CE_WORK_ORDER_LINES');
1875:
1876: EXCEPTION
1877: WHEN FND_API.G_EXC_ERROR THEN
1878: x_return_status := 'E';
1879: debug('In to FND_API.G_EXC_ERROR in POPULATE_CE_WORK_ORDER_LINES');
1880: WHEN OTHERS THEN
1881: x_return_status := 'E';
1875:
1876: EXCEPTION
1877: WHEN FND_API.G_EXC_ERROR THEN
1878: x_return_status := 'E';
1879: debug('In to FND_API.G_EXC_ERROR in POPULATE_CE_WORK_ORDER_LINES');
1880: WHEN OTHERS THEN
1881: x_return_status := 'E';
1882: debug('In to Others exception in POPULATE_CE_WORK_ORDER_LINES');
1883: END POPULATE_CE_WORK_ORDER_LINES;
1950: l_index NUMBER := 0;
1951: BEGIN
1952: SAVEPOINT GET_CU_RECS;
1953:
1954: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: END IF;
1957:
1958: --Initialize message list if p_init_msg_list is set to TRUE.
1951: BEGIN
1952: SAVEPOINT GET_CU_RECS;
1953:
1954: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: END IF;
1957:
1958: --Initialize message list if p_init_msg_list is set to TRUE.
1959: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: END IF;
1957:
1958: --Initialize message list if p_init_msg_list is set to TRUE.
1959: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1960: FND_MSG_PUB.INITIALIZE;
1961: END IF;
1962:
1963: --Initialize API return status to success
1960: FND_MSG_PUB.INITIALIZE;
1961: END IF;
1962:
1963: --Initialize API return status to success
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;
1965:
1966: INIT_DEBUG(
1967: p_init_msg_list => p_init_msg_list,
1968: p_debug_filename => l_debug_filename,
2012: WHEN OTHERS THEN
2013: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CU_ID');
2014: FND_MESSAGE.SET_TOKEN('CU_ID', px_cu_tbl(l_index).CU_ID);
2015: FND_MSG_PUB.ADD;
2016: RAISE FND_API.G_EXC_ERROR;
2017: END;
2018: END LOOP;
2019: END IF;
2020: EXCEPTION
2017: END;
2018: END LOOP;
2019: END IF;
2020: EXCEPTION
2021: WHEN FND_API.G_EXC_ERROR THEN
2022: ROLLBACK TO GET_CU_RECS;
2023: x_return_status := FND_API.G_RET_STS_ERROR;
2024: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2025: p_count => x_msg_count,
2019: END IF;
2020: EXCEPTION
2021: WHEN FND_API.G_EXC_ERROR THEN
2022: ROLLBACK TO GET_CU_RECS;
2023: x_return_status := FND_API.G_RET_STS_ERROR;
2024: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2025: p_count => x_msg_count,
2026: p_data => x_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2023: x_return_status := FND_API.G_RET_STS_ERROR;
2024: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2025: p_count => x_msg_count,
2026: p_data => x_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO GET_CU_RECS;
2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2030: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2031: p_count => x_msg_count,
2025: p_count => x_msg_count,
2026: p_data => x_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO GET_CU_RECS;
2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2030: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2031: p_count => x_msg_count,
2032: p_data => x_msg_data);
2033: WHEN OTHERS THEN
2031: p_count => x_msg_count,
2032: p_data => x_msg_data);
2033: WHEN OTHERS THEN
2034: ROLLBACK TO GET_CU_RECS;
2035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2036: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2037: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2038: END IF;
2039: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2075: l_activities_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
2076: BEGIN
2077: SAVEPOINT GET_CU_ACTIVITIES;
2078:
2079: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2081: END IF;
2082:
2083: --Initialize message list if p_init_msg_list is set to TRUE.
2076: BEGIN
2077: SAVEPOINT GET_CU_ACTIVITIES;
2078:
2079: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2081: END IF;
2082:
2083: --Initialize message list if p_init_msg_list is set to TRUE.
2084: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2081: END IF;
2082:
2083: --Initialize message list if p_init_msg_list is set to TRUE.
2084: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2085: FND_MSG_PUB.INITIALIZE;
2086: END IF;
2087:
2088: --Initialize API return status to success
2085: FND_MSG_PUB.INITIALIZE;
2086: END IF;
2087:
2088: --Initialize API return status to success
2089: x_return_status := FND_API.G_RET_STS_SUCCESS;
2090:
2091: INIT_DEBUG(
2092: p_init_msg_list => p_init_msg_list,
2093: p_debug_filename => l_debug_filename,
2166: DEBUG('x_return_status : ' || x_return_status);
2167: DEBUG('x_msg_count : ' || x_msg_count);
2168: END IF;
2169: EXCEPTION
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO GET_CU_ACTIVITIES;
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2174: p_count => x_msg_count,
2168: END IF;
2169: EXCEPTION
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO GET_CU_ACTIVITIES;
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2174: p_count => x_msg_count,
2175: p_data => x_msg_data);
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2174: p_count => x_msg_count,
2175: p_data => x_msg_data);
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2177: ROLLBACK TO GET_CU_ACTIVITIES;
2178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2179: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2180: p_count => x_msg_count,
2174: p_count => x_msg_count,
2175: p_data => x_msg_data);
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2177: ROLLBACK TO GET_CU_ACTIVITIES;
2178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2179: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2180: p_count => x_msg_count,
2181: p_data => x_msg_data);
2182: WHEN OTHERS THEN
2180: p_count => x_msg_count,
2181: p_data => x_msg_data);
2182: WHEN OTHERS THEN
2183: ROLLBACK TO GET_CU_ACTIVITIES;
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2186: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2187: END IF;
2188: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2215:
2216: BEGIN
2217: SAVEPOINT CREATE_ESTIMATE;
2218:
2219: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2221: END IF;
2222:
2223: --Initialize message list if p_init_msg_list is set to TRUE.
2216: BEGIN
2217: SAVEPOINT CREATE_ESTIMATE;
2218:
2219: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2221: END IF;
2222:
2223: --Initialize message list if p_init_msg_list is set to TRUE.
2224: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2221: END IF;
2222:
2223: --Initialize message list if p_init_msg_list is set to TRUE.
2224: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2225: FND_MSG_PUB.INITIALIZE;
2226: END IF;
2227:
2228: --Initialize API return status to success
2225: FND_MSG_PUB.INITIALIZE;
2226: END IF;
2227:
2228: --Initialize API return status to success
2229: x_return_status := FND_API.G_RET_STS_SUCCESS;
2230:
2231: INIT_DEBUG(
2232: p_init_msg_list => p_init_msg_list,
2233: p_debug_filename => l_debug_filename,
2253: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2254: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
2255: FND_MESSAGE.SET_TOKEN('VALUE', px_estimate_rec.ORGANIZATION_ID);
2256: FND_MSG_PUB.ADD;
2257: RAISE FND_API.G_EXC_ERROR;
2258: END IF;
2259:
2260: IF (px_estimate_rec.ESTIMATE_NUMBER IS NULL) THEN
2261: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2261: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2262: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_NUMBER');
2263: FND_MESSAGE.SET_TOKEN('VALUE', px_estimate_rec.ESTIMATE_NUMBER);
2264: FND_MSG_PUB.ADD;
2265: RAISE FND_API.G_EXC_ERROR;
2266: ELSE
2267: BEGIN
2268: SELECT 'Y'
2269: INTO l_estimate_exist
2277: IF l_estimate_exist = 'Y' THEN
2278: FND_MESSAGE.SET_NAME('EAM','EAM_ESTIMATE_NAME_UNIQUE');
2279: FND_MESSAGE.SET_TOKEN('ESTIMATE_NAME', px_estimate_rec.ESTIMATE_NUMBER);
2280: FND_MSG_PUB.ADD;
2281: RAISE FND_API.G_EXC_ERROR;
2282: END IF;
2283: END IF;
2284:
2285:
2318: IF (l_debug = 'Y') THEN
2319: DEBUG('Created estimate with ID : ' || px_estimate_rec.ESTIMATE_ID);
2320: END IF;
2321:
2322: IF (p_commit = FND_API.G_TRUE) THEN
2323: COMMIT;
2324: END IF;
2325:
2326: IF (l_debug = 'Y') THEN
2327: DEBUG('x_return_status : ' || x_return_status);
2328: DEBUG('x_msg_count : ' || x_msg_count);
2329: END IF;
2330: EXCEPTION
2331: WHEN FND_API.G_EXC_ERROR THEN
2332: ROLLBACK TO CREATE_ESTIMATE;
2333: x_return_status := FND_API.G_RET_STS_ERROR;
2334: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2335: p_count => x_msg_count,
2329: END IF;
2330: EXCEPTION
2331: WHEN FND_API.G_EXC_ERROR THEN
2332: ROLLBACK TO CREATE_ESTIMATE;
2333: x_return_status := FND_API.G_RET_STS_ERROR;
2334: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2335: p_count => x_msg_count,
2336: p_data => x_msg_data);
2337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2333: x_return_status := FND_API.G_RET_STS_ERROR;
2334: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2335: p_count => x_msg_count,
2336: p_data => x_msg_data);
2337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2338: ROLLBACK TO CREATE_ESTIMATE;
2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2340: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2341: p_count => x_msg_count,
2335: p_count => x_msg_count,
2336: p_data => x_msg_data);
2337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2338: ROLLBACK TO CREATE_ESTIMATE;
2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2340: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2341: p_count => x_msg_count,
2342: p_data => x_msg_data);
2343: WHEN OTHERS THEN
2341: p_count => x_msg_count,
2342: p_data => x_msg_data);
2343: WHEN OTHERS THEN
2344: ROLLBACK TO CREATE_ESTIMATE;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2347: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2348: END IF;
2349: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2371: l_last_updated_date DATE := SYSDATE;
2372: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2373: l_last_updated_login NUMBER;
2374: l_estimate_exist VARCHAR2(1) := 'N';
2375: l_parent_creation_flag VARCHAR(1) := FND_API.G_MISS_CHAR;
2376: l_parent_wo_id NUMBER := FND_API.G_MISS_NUM;
2377: l_validate boolean;
2378: x_error_segments number;
2379: x_error_message varchar2(2000);
2372: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2373: l_last_updated_login NUMBER;
2374: l_estimate_exist VARCHAR2(1) := 'N';
2375: l_parent_creation_flag VARCHAR(1) := FND_API.G_MISS_CHAR;
2376: l_parent_wo_id NUMBER := FND_API.G_MISS_NUM;
2377: l_validate boolean;
2378: x_error_segments number;
2379: x_error_message varchar2(2000);
2380: l_attribute_category VARCHAR2(240);
2381:
2382: BEGIN
2383: SAVEPOINT UPDATE_ESTIMATE;
2384:
2385: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: END IF;
2388:
2389: --Initialize message list if p_init_msg_list is set to TRUE.
2382: BEGIN
2383: SAVEPOINT UPDATE_ESTIMATE;
2384:
2385: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: END IF;
2388:
2389: --Initialize message list if p_init_msg_list is set to TRUE.
2390: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: END IF;
2388:
2389: --Initialize message list if p_init_msg_list is set to TRUE.
2390: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2391: FND_MSG_PUB.INITIALIZE;
2392: END IF;
2393:
2394: --Initialize API return status to success
2391: FND_MSG_PUB.INITIALIZE;
2392: END IF;
2393:
2394: --Initialize API return status to success
2395: x_return_status := FND_API.G_RET_STS_SUCCESS;
2396:
2397: INIT_DEBUG(
2398: p_init_msg_list => p_init_msg_list,
2399: p_debug_filename => l_debug_filename,
2419: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2420: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_ID');
2421: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_rec.ESTIMATE_ID);
2422: FND_MSG_PUB.ADD;
2423: RAISE FND_API.G_EXC_ERROR;
2424: END IF;
2425:
2426: IF (p_estimate_rec.ORGANIZATION_ID IS NULL) THEN
2427: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2427: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2428: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
2429: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_rec.ORGANIZATION_ID);
2430: FND_MSG_PUB.ADD;
2431: RAISE FND_API.G_EXC_ERROR;
2432: END IF;
2433:
2434: IF (p_estimate_rec.ESTIMATE_NUMBER IS NULL) THEN
2435: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2435: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2436: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_NUMBER');
2437: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_rec.ESTIMATE_NUMBER);
2438: FND_MSG_PUB.ADD;
2439: RAISE FND_API.G_EXC_ERROR;
2440: ELSE
2441: BEGIN
2442: SELECT 'Y'
2443: INTO l_estimate_exist
2452: IF l_estimate_exist = 'Y' THEN
2453: FND_MESSAGE.SET_NAME('EAM','EAM_ESTIMATE_NAME_UNIQUE');
2454: FND_MESSAGE.SET_TOKEN('ESTIMATE_NAME', p_estimate_rec.ESTIMATE_NUMBER);
2455: FND_MSG_PUB.ADD;
2456: RAISE FND_API.G_EXC_ERROR;
2457: END IF;
2458: END IF;
2459:
2460: -- Verifying data
2457: END IF;
2458: END IF;
2459:
2460: -- Verifying data
2461: IF NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM OR
2462: p_estimate_rec.PARENT_WO_ID IS NOT NULL THEN
2463: l_parent_wo_id := p_estimate_rec.PARENT_WO_ID;
2464: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2465:
2460: -- Verifying data
2461: IF NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM OR
2462: p_estimate_rec.PARENT_WO_ID IS NOT NULL THEN
2463: l_parent_wo_id := p_estimate_rec.PARENT_WO_ID;
2464: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2465:
2466: IF NVL(p_estimate_rec.CREATE_PARENT_WO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR OR
2467: p_estimate_rec.CREATE_PARENT_WO_FLAG IS NOT NULL THEN
2468: l_parent_creation_flag := p_estimate_rec.CREATE_PARENT_WO_FLAG;
2462: p_estimate_rec.PARENT_WO_ID IS NOT NULL THEN
2463: l_parent_wo_id := p_estimate_rec.PARENT_WO_ID;
2464: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2465:
2466: IF NVL(p_estimate_rec.CREATE_PARENT_WO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR OR
2467: p_estimate_rec.CREATE_PARENT_WO_FLAG IS NOT NULL THEN
2468: l_parent_creation_flag := p_estimate_rec.CREATE_PARENT_WO_FLAG;
2469: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2470:
2465:
2466: IF NVL(p_estimate_rec.CREATE_PARENT_WO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR OR
2467: p_estimate_rec.CREATE_PARENT_WO_FLAG IS NOT NULL THEN
2468: l_parent_creation_flag := p_estimate_rec.CREATE_PARENT_WO_FLAG;
2469: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2470:
2471: -- Bug 13498107
2472: -- Validation of Description Flexfields
2473: l_attribute_category := p_estimate_rec.attribute_category;
2470:
2471: -- Bug 13498107
2472: -- Validation of Description Flexfields
2473: l_attribute_category := p_estimate_rec.attribute_category;
2474: IF (NVL(l_attribute_category, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
2475: l_attribute_category := null;
2476: END IF;
2477:
2478: l_validate := EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field (
2500: IF (not l_validate) THEN
2501: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
2502: FND_MESSAGE.SET_TOKEN('ERROR_MSG', x_error_message);
2503: FND_MSG_PUB.Add;
2504: RAISE FND_API.G_EXC_ERROR;
2505: END IF;
2506:
2507:
2508: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
2539: IF (l_debug = 'Y') THEN
2540: DEBUG('Update estimate with ID : ' || p_estimate_rec.ESTIMATE_ID);
2541: END IF;
2542:
2543: IF (p_commit = FND_API.G_TRUE) THEN
2544: COMMIT;
2545: END IF;
2546:
2547: IF (l_debug = 'Y') THEN
2548: DEBUG('x_return_status : ' || x_return_status);
2549: DEBUG('x_msg_count : ' || x_msg_count);
2550: END IF;
2551: EXCEPTION
2552: WHEN FND_API.G_EXC_ERROR THEN
2553: ROLLBACK TO UPDATE_ESTIMATE;
2554: x_return_status := FND_API.G_RET_STS_ERROR;
2555: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2556: p_count => x_msg_count,
2550: END IF;
2551: EXCEPTION
2552: WHEN FND_API.G_EXC_ERROR THEN
2553: ROLLBACK TO UPDATE_ESTIMATE;
2554: x_return_status := FND_API.G_RET_STS_ERROR;
2555: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2556: p_count => x_msg_count,
2557: p_data => x_msg_data);
2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2554: x_return_status := FND_API.G_RET_STS_ERROR;
2555: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2556: p_count => x_msg_count,
2557: p_data => x_msg_data);
2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2559: ROLLBACK TO UPDATE_ESTIMATE;
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2561: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2562: p_count => x_msg_count,
2556: p_count => x_msg_count,
2557: p_data => x_msg_data);
2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2559: ROLLBACK TO UPDATE_ESTIMATE;
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2561: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2562: p_count => x_msg_count,
2563: p_data => x_msg_data);
2564: WHEN OTHERS THEN
2562: p_count => x_msg_count,
2563: p_data => x_msg_data);
2564: WHEN OTHERS THEN
2565: ROLLBACK TO UPDATE_ESTIMATE;
2566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2568: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2569: END IF;
2570: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2606: l_last_updated_login NUMBER;
2607: BEGIN
2608: SAVEPOINT SET_ACTIVITIES_FOR_CE;
2609:
2610: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: END IF;
2613:
2614: --Initialize message list if p_init_msg_list is set to TRUE.
2607: BEGIN
2608: SAVEPOINT SET_ACTIVITIES_FOR_CE;
2609:
2610: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: END IF;
2613:
2614: --Initialize message list if p_init_msg_list is set to TRUE.
2615: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: END IF;
2613:
2614: --Initialize message list if p_init_msg_list is set to TRUE.
2615: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2616: FND_MSG_PUB.INITIALIZE;
2617: END IF;
2618:
2619: --Initialize API return status to success
2616: FND_MSG_PUB.INITIALIZE;
2617: END IF;
2618:
2619: --Initialize API return status to success
2620: x_return_status := FND_API.G_RET_STS_SUCCESS;
2621:
2622: INIT_DEBUG(
2623: p_init_msg_list => p_init_msg_list,
2624: p_debug_filename => l_debug_filename,
2655: IF p_ce_id IS NULL THEN
2656: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CE_ID');
2657: FND_MESSAGE.SET_TOKEN('CE_ID', p_ce_id);
2658: FND_MSG_PUB.ADD;
2659: RAISE FND_API.G_EXC_ERROR;
2660: END IF;
2661:
2662: BEGIN
2663: SELECT ESTIMATE_ID,
2670: WHEN OTHERS THEN
2671: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CE_ID');
2672: FND_MESSAGE.SET_TOKEN('CE_ID', p_ce_id);
2673: FND_MSG_PUB.ADD;
2674: RAISE FND_API.G_EXC_ERROR;
2675: END;
2676:
2677: IF px_activities_tbl.COUNT > 0 THEN
2678: l_index := 0;
2682: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2683: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
2684: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ORGANIZATION_ID);
2685: FND_MSG_PUB.ADD;
2686: RAISE FND_API.G_EXC_ERROR;
2687: END IF;
2688:
2689: IF (px_activities_tbl(l_index).ESTIMATE_ID IS NOT NULL AND px_activities_tbl(l_index).ESTIMATE_ID <> l_ce_id) THEN
2690: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2690: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2691: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ESTIMATE_ID);
2693: FND_MSG_PUB.ADD;
2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;
2696:
2697: l_cu_id := px_activities_tbl(l_index).CU_ID;
2698:
2700: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2701: FND_MESSAGE.SET_TOKEN('PARAMETER', 'CU_QTY');
2702: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).CU_QTY);
2703: FND_MSG_PUB.ADD;
2704: RAISE FND_API.G_EXC_ERROR;
2705: END IF;
2706: l_cu_qty := px_activities_tbl(l_index).CU_QTY;
2707:
2708: /*IF (px_activities_tbl(l_index).ACCT_CLASS_CODE IS NULL) THEN
2709: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2710: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ACCT_CLASS_CODE');
2711: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ACCT_CLASS_CODE);
2712: FND_MSG_PUB.ADD;
2713: RAISE FND_API.G_EXC_ERROR;
2714: END IF;*/
2715: l_acct_class_code := px_activities_tbl(l_index).ACCT_CLASS_CODE;
2716:
2717: IF (px_activities_tbl(l_index).ACTIVITY_ID IS NULL) THEN
2718: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2719: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ACTIVITY_ID');
2720: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ACTIVITY_ID);
2721: FND_MSG_PUB.ADD;
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724: l_activity_id := px_activities_tbl(l_index).ACTIVITY_ID;
2725:
2726: IF (px_activities_tbl(l_index).ACTIVITY_QTY IS NULL) THEN
2727: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2728: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ACTIVITY_QTY');
2729: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ACTIVITY_QTY);
2730: FND_MSG_PUB.ADD;
2731: RAISE FND_API.G_EXC_ERROR;
2732: END IF;
2733: l_activity_qty := px_activities_tbl(l_index).ACTIVITY_QTY;
2734:
2735: l_difficulty_id := px_activities_tbl(l_index).DIFFICULTY_ID;
2738: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2739: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RESOURCE_MULTIPLIER');
2740: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).RESOURCE_MULTIPLIER);
2741: FND_MSG_PUB.ADD;
2742: RAISE FND_API.G_EXC_ERROR;
2743: END IF;
2744: l_resource_multiplier := px_activities_tbl(l_index).RESOURCE_MULTIPLIER;
2745: l_est_association_id := NULL;
2746:
2768: px_activities_tbl(l_index).ESTIMATE_ASSOCIATION_ID := l_est_association_id;
2769: END LOOP;
2770: END IF;
2771:
2772: IF (p_commit = FND_API.G_TRUE) THEN
2773: COMMIT;
2774: END IF;
2775:
2776: IF (l_debug = 'Y') THEN
2777: DEBUG('x_return_status : ' || x_return_status);
2778: DEBUG('x_msg_count : ' || x_msg_count);
2779: END IF;
2780: EXCEPTION
2781: WHEN FND_API.G_EXC_ERROR THEN
2782: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2785: p_count => x_msg_count,
2779: END IF;
2780: EXCEPTION
2781: WHEN FND_API.G_EXC_ERROR THEN
2782: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2785: p_count => x_msg_count,
2786: p_data => x_msg_data);
2787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2785: p_count => x_msg_count,
2786: p_data => x_msg_data);
2787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2788: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2790: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2791: p_count => x_msg_count,
2785: p_count => x_msg_count,
2786: p_data => x_msg_data);
2787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2788: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2790: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2791: p_count => x_msg_count,
2792: p_data => x_msg_data);
2793: WHEN OTHERS THEN
2791: p_count => x_msg_count,
2792: p_data => x_msg_data);
2793: WHEN OTHERS THEN
2794: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2796: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2798: END IF;
2799: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3118: --Unsupported group option
3119: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3120: FND_MESSAGE.SET_TOKEN('OPTION', p_group_option);
3121: FND_MSG_PUB.ADD;
3122: RAISE FND_API.G_EXC_ERROR;
3123: END IF;
3124: END GET_CE_WO_LNS_BY_GROUP_OPT;
3125:
3126: --This is a private procedure, it takes a wo defaults record and a list of wo
3178: --Unsupported group option
3179: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3180: FND_MESSAGE.SET_TOKEN('OPTION', p_group_option);
3181: FND_MSG_PUB.ADD;
3182: RAISE FND_API.G_EXC_ERROR;
3183: END IF;
3184: END IF;
3185: END LOOP;
3186: END IF;
3404: --Unsupported group option
3405: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3406: FND_MESSAGE.SET_TOKEN('OPTION', p_group_option);
3407: FND_MSG_PUB.ADD;
3408: RAISE FND_API.G_EXC_ERROR;
3409: END IF;
3410: END LOOP;
3411: END IF;
3412: END RESOLVE_SORT_CONTENTION;
3433: l_ce_wo_ln_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
3434: BEGIN
3435: SAVEPOINT UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3436:
3437: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3439: END IF;
3440:
3441: --Initialize message list if p_init_msg_list is set to TRUE.
3434: BEGIN
3435: SAVEPOINT UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3436:
3437: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3439: END IF;
3440:
3441: --Initialize message list if p_init_msg_list is set to TRUE.
3442: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
3438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3439: END IF;
3440:
3441: --Initialize message list if p_init_msg_list is set to TRUE.
3442: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
3443: FND_MSG_PUB.INITIALIZE;
3444: END IF;
3445:
3446: --Initialize API return status to success
3443: FND_MSG_PUB.INITIALIZE;
3444: END IF;
3445:
3446: --Initialize API return status to success
3447: x_return_status := FND_API.G_RET_STS_SUCCESS;
3448:
3449: INIT_DEBUG(
3450: p_init_msg_list => p_init_msg_list,
3451: p_debug_filename => l_debug_filename,
3491: --Unsupported group option
3492: FND_MESSAGE.SET_NAME('EAM','EAM_ERROR_DERIVE_GROUP_OPTION');
3493: FND_MESSAGE.SET_TOKEN('OPTION_ID', p_ce_wo_defaults.GROUPING_OPTION);
3494: FND_MSG_PUB.ADD;
3495: RAISE FND_API.G_EXC_ERROR;
3496: END;
3497:
3498: IF l_group_option = 'None'
3499: OR l_group_option = 'Activity'
3521: --Unsupported group option
3522: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3523: FND_MESSAGE.SET_TOKEN('OPTION', l_group_option);
3524: FND_MSG_PUB.ADD;
3525: RAISE FND_API.G_EXC_ERROR;
3526: END IF;
3527:
3528: --Now update the wo lines
3529: IF l_ce_wo_ln_tbl.COUNT > 0 THEN
3529: IF l_ce_wo_ln_tbl.COUNT > 0 THEN
3530: FOR i IN l_ce_wo_ln_tbl.FIRST..l_ce_wo_ln_tbl.LAST LOOP
3531: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
3532: p_estimate_work_order_line_id => l_ce_wo_ln_tbl(i).ESTIMATE_WORK_ORDER_LINE_ID,
3533: p_estimate_work_order_id => FND_API.G_MISS_NUM,
3534: p_src_cu_id => l_ce_wo_ln_tbl(i).SRC_CU_ID,
3535: p_src_activity_id => l_ce_wo_ln_tbl(i).SRC_ACTIVITY_ID,
3536: p_src_activity_qty => l_ce_wo_ln_tbl(i).SRC_ACTIVITY_QTY,
3537: p_src_op_seq_num => l_ce_wo_ln_tbl(i).SRC_OP_SEQ_NUM,
3587: p_di_purchase_category_id => l_ce_wo_ln_tbl(i).DI_PURCHASE_CATEGORY_ID,
3588: p_di_auto_request_material => l_ce_wo_ln_tbl(i).DI_AUTO_REQUEST_MATERIAL,
3589: p_di_need_by_date => l_ce_wo_ln_tbl(i).DI_NEED_BY_DATE,
3590: p_work_order_line_cost => l_ce_wo_ln_tbl(i).WORK_ORDER_LINE_COST,
3591: p_creation_date => FND_API.G_MISS_DATE,
3592: p_created_by => FND_API.G_MISS_NUM,
3593: p_last_update_date => SYSDATE,
3594: p_last_updated_by => FND_GLOBAL.USER_ID,
3595: p_last_update_login => FND_GLOBAL.USER_ID
3588: p_di_auto_request_material => l_ce_wo_ln_tbl(i).DI_AUTO_REQUEST_MATERIAL,
3589: p_di_need_by_date => l_ce_wo_ln_tbl(i).DI_NEED_BY_DATE,
3590: p_work_order_line_cost => l_ce_wo_ln_tbl(i).WORK_ORDER_LINE_COST,
3591: p_creation_date => FND_API.G_MISS_DATE,
3592: p_created_by => FND_API.G_MISS_NUM,
3593: p_last_update_date => SYSDATE,
3594: p_last_updated_by => FND_GLOBAL.USER_ID,
3595: p_last_update_login => FND_GLOBAL.USER_ID
3596: ,p_work_order_type => l_ce_wo_ln_tbl(i).WORK_ORDER_TYPE
3603: ,p_res_sch_flag => l_ce_wo_ln_tbl(i).RES_SCHEDULED_FLAG);
3604: END LOOP;
3605: END IF;
3606:
3607: IF p_commit = FND_API.G_TRUE THEN
3608: COMMIT;
3609: END IF;
3610: EXCEPTION
3611: WHEN FND_API.G_EXC_ERROR THEN
3607: IF p_commit = FND_API.G_TRUE THEN
3608: COMMIT;
3609: END IF;
3610: EXCEPTION
3611: WHEN FND_API.G_EXC_ERROR THEN
3612: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3613: x_return_status := FND_API.G_RET_STS_ERROR;
3614: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3615: p_count => x_msg_count,
3609: END IF;
3610: EXCEPTION
3611: WHEN FND_API.G_EXC_ERROR THEN
3612: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3613: x_return_status := FND_API.G_RET_STS_ERROR;
3614: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3615: p_count => x_msg_count,
3616: p_data => x_msg_data);
3617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3613: x_return_status := FND_API.G_RET_STS_ERROR;
3614: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3615: p_count => x_msg_count,
3616: p_data => x_msg_data);
3617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3618: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3620: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3621: p_count => x_msg_count,
3615: p_count => x_msg_count,
3616: p_data => x_msg_data);
3617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3618: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3620: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3621: p_count => x_msg_count,
3622: p_data => x_msg_data);
3623: WHEN OTHERS THEN
3621: p_count => x_msg_count,
3622: p_data => x_msg_data);
3623: WHEN OTHERS THEN
3624: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3627: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3628: END IF;
3629: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3632: END UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3633:
3634: PROCEDURE CREATE_CU_WORKORDERS(
3635: p_api_version IN NUMBER := 1.0
3636: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3637: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3638: ,p_estimate_id IN NUMBER
3639: ,x_return_status OUT NOCOPY VARCHAR2
3640: ,x_msg_count OUT NOCOPY NUMBER
3633:
3634: PROCEDURE CREATE_CU_WORKORDERS(
3635: p_api_version IN NUMBER := 1.0
3636: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3637: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3638: ,p_estimate_id IN NUMBER
3639: ,x_return_status OUT NOCOPY VARCHAR2
3640: ,x_msg_count OUT NOCOPY NUMBER
3641: ,x_msg_data OUT NOCOPY VARCHAR2
3784:
3785: -------------------------------------------------------------------------
3786: -- standard call to check for call compatibility
3787: -------------------------------------------------------------------------
3788: IF NOT fnd_api.compatible_api_call (
3789: l_api_version,
3790: p_api_version,
3791: l_api_name,
3792: G_PKG_NAME ) then
3790: p_api_version,
3791: l_api_name,
3792: G_PKG_NAME ) then
3793:
3794: RAISE fnd_api.g_exc_unexpected_error;
3795:
3796: END IF;
3797:
3798: -------------------------------------------------------------------------
3798: -------------------------------------------------------------------------
3799: -- Initialize message list if p_init_msg_list is set to TRUE
3800: -------------------------------------------------------------------------
3801: --dbms_output.put_line('2');
3802: IF FND_API.to_Boolean(p_init_msg_list) THEN
3803: FND_MSG_PUB.initialize;
3804: END IF;
3805:
3806:
3806:
3807: -------------------------------------------------------------------------
3808: -- initialize api return status to success
3809: -------------------------------------------------------------------------
3810: x_return_status := fnd_api.g_ret_sts_success;
3811:
3812: -- assign to local variables
3813: l_stmt_num := 10;
3814:
3868: , x_mesg_token_tbl => l_out_mesg_token_tbl
3869: );
3870: l_mesg_token_tbl := l_out_mesg_token_tbl;
3871:
3872: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3873: THEN
3874: --dbms_output.put_line ('Unable to open file for debug');
3875: EAM_PROCESS_WO_PVT.Set_Debug('N');
3876: END IF;
3921:
3922: IF l_wo_seq_exists = 1 THEN
3923: /* lOG errro */
3924: --dbms_output.put_line('4');
3925: RAISE FND_API.g_exc_error;
3926: END IF;
3927:
3928: EXCEPTION
3929: WHEN NO_DATA_FOUND THEN
3950:
3951: IF l_wo_exists = 1 THEN
3952: /* lOG errro */
3953: --dbms_output.put_line('4');
3954: RAISE FND_API.g_exc_error;
3955: END IF;
3956:
3957: EXCEPTION
3958: WHEN NO_DATA_FOUND THEN
3977:
3978: IF l_noasset = 1 THEN
3979: /* lOG errro */
3980: --dbms_output.put_line('4');
3981: RAISE FND_API.g_exc_error;
3982: END IF;
3983:
3984: EXCEPTION
3985: WHEN NO_DATA_FOUND THEN
4021: , x_msg_count => l_msg_count
4022: , x_msg_data => l_msg_data);
4023: --dbms_output.put_line('Back Calling PWO');
4024:
4025: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4026: --dbms_output.put_line('New WO error...');
4027: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4028: l_api_message := 'Populate_WO returned error';
4029: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4028: l_api_message := 'Populate_WO returned error';
4029: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4030: FND_MESSAGE.set_token('TEXT', l_api_message);
4031: FND_MSG_pub.add;
4032: RAISE FND_API.g_exc_error;
4033: END IF;
4034:
4035: l_eam_wo_tbl(1) := l_eam_wo_rec;
4036: --dbms_output.put_line('Calling WO API for parent');
4090:
4091: IF(x_return_status <> 'S') then
4092: --dbms_output.put_line('Error after creating pwo' || SQLERRM);
4093: -- ROLLBACK TO CREATE_CU_WORKORDERS;
4094: RAISE FND_API.G_EXC_ERROR;
4095: END IF;
4096:
4097: UPDATE EAM_CE_WORK_ORDER_LINES
4098: SET estimate_work_order_id = l_eam_wo_tbl1(1).wip_entity_id
4108:
4109: EXCEPTION
4110: WHEN OTHERS THEN
4111: --dbms_output.put_line('Creating parent 2' || l_stmt_num || SQLERRM);
4112: RAISE FND_API.g_exc_error;
4113: END;
4114:
4115:
4116: END IF;
4115:
4116: END IF;
4117: EXCEPTION
4118: WHEN OTHERS THEN
4119: RAISE FND_API.g_exc_error;
4120:
4121: END;
4122:
4123: -------------------------------------------------------------------------
4159: , x_return_status => l_return_status
4160: , x_msg_count => l_msg_count
4161: , x_msg_data => l_msg_data);
4162:
4163: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4164: --dbms_output.put_line('New WO error...' || wo);
4165: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4166: l_api_message := 'Populate_WO returned error';
4167: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4166: l_api_message := 'Populate_WO returned error';
4167: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4168: FND_MESSAGE.set_token('TEXT', l_api_message);
4169: FND_MSG_pub.add;
4170: RAISE FND_API.g_exc_error;
4171: END IF;
4172:
4173:
4174: l_eam_wo_tbl(wo) := l_eam_wo_rec;
4214: , x_msg_count => l_msg_count
4215: , x_msg_data => l_msg_data);
4216:
4217:
4218: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4219: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4220: l_api_message := 'POPULATE_OPERATION returned error';
4221: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4222: FND_MESSAGE.set_token('TEXT', l_api_message);
4220: l_api_message := 'POPULATE_OPERATION returned error';
4221: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4222: FND_MESSAGE.set_token('TEXT', l_api_message);
4223: FND_MSG_pub.add;
4224: RAISE FND_API.g_exc_error;
4225: END IF;
4226:
4227:
4228: l_eam_op_tbl(op) := l_eam_op_rec;
4232:
4233: l_res_seq := c_ecwl_rec.res_id;
4234: --dbms_output.put_line('Inside resource- ID...' || l_res_seq);
4235:
4236: IF (l_res_seq IS NOT null) OR (l_res_seq <> -99) OR (l_res_seq <> FND_API.G_MISS_NUM) THEN
4237: --dbms_output.put_line('Inside resource...' || l_eam_wo_tbl(1).header_id);
4238: /* This is a Resource Line */
4239: l_stmt_num := 120;
4240: res := res + 1;
4249: , x_msg_count => l_msg_count
4250: , x_msg_data => l_msg_data);
4251:
4252:
4253: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4254: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4255: l_api_message := 'POPULATE_RESOURCE returned error';
4256: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4257: FND_MESSAGE.set_token('TEXT', l_api_message);
4255: l_api_message := 'POPULATE_RESOURCE returned error';
4256: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4257: FND_MESSAGE.set_token('TEXT', l_api_message);
4258: FND_MSG_pub.add;
4259: RAISE FND_API.g_exc_error;
4260: END IF;
4261:
4262:
4263: l_eam_res_tbl(res) := l_eam_res_rec;
4266:
4267: l_mat_seq := c_ecwl_rec.mat_inventory_item_id;
4268: --dbms_output.put_line('Inside material- ID...' || l_mat_seq);
4269:
4270: IF (l_mat_seq IS NOT null) OR (l_mat_seq <> -99) OR (l_mat_seq <> FND_API.G_MISS_NUM) THEN
4271: --dbms_output.put_line('Inside mat...' || l_eam_wo_tbl(1).header_id);
4272: /* This is a Material Line */
4273: l_stmt_num := 140;
4274: mat := mat + 1;
4284: , x_msg_count => l_msg_count
4285: , x_msg_data => l_msg_data);
4286:
4287:
4288: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4289: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4290: l_api_message := 'POPULATE_MATERIAL returned error';
4291: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4292: FND_MESSAGE.set_token('TEXT', l_api_message);
4290: l_api_message := 'POPULATE_MATERIAL returned error';
4291: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4292: FND_MESSAGE.set_token('TEXT', l_api_message);
4293: FND_MSG_pub.add;
4294: RAISE FND_API.g_exc_error;
4295: END IF;
4296:
4297:
4298: l_eam_mat_req_tbl(mat) := l_eam_mat_rec;
4301:
4302: l_direct_desc := c_ecwl_rec.di_description;
4303: --dbms_output.put_line('Inside direct- ID...' || l_direct_desc);
4304:
4305: IF (l_direct_desc IS NOT null) OR (l_direct_desc <> FND_API.G_MISS_CHAR) THEN
4306: --dbms_output.put_line('Inside direct...' || l_eam_wo_tbl(1).header_id);
4307: /* This is a Material Line */
4308: l_stmt_num := 160;
4309: di := di + 1;
4319: , x_msg_count => l_msg_count
4320: , x_msg_data => l_msg_data);
4321:
4322:
4323: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4324: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4325: l_api_message := 'POPULATE_MATERIAL returned error';
4326: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4327: FND_MESSAGE.set_token('TEXT', l_api_message);
4325: l_api_message := 'POPULATE_MATERIAL returned error';
4326: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4327: FND_MESSAGE.set_token('TEXT', l_api_message);
4328: FND_MSG_pub.add;
4329: RAISE FND_API.g_exc_error;
4330: END IF;
4331:
4332:
4333: l_eam_direct_items_tbl(di) := l_eam_direct_rec;
4400: x_msg_count := l_msg_count;
4401:
4402:
4403: IF(x_return_status<>'S') then
4404: RAISE FND_API.G_EXC_ERROR;
4405: END IF;
4406:
4407: END IF; -- l_eam_wo_tbl.count > 0
4408: l_stmt_num := 402;
4424: AND organization_id = l_eam_wo_tbl1(i).organization_id;
4425:
4426: EXCEPTION
4427: WHEN OTHERS THEN
4428: RAISE FND_API.G_EXC_ERROR;
4429: END;
4430: END LOOP;
4431: END IF; -- l_eam_wo_tbl1.count > 0
4432: COMMIT;
4432: COMMIT;
4433:
4434: EXCEPTION
4435:
4436: WHEN fnd_api.g_exc_error THEN
4437: --ROLLBACK TO
4438: ROLLBACK TO CREATE_CU_WORKORDERS;
4439: x_return_status := fnd_api.g_ret_sts_error;
4440: --dbms_output.put_line('exzc');
4435:
4436: WHEN fnd_api.g_exc_error THEN
4437: --ROLLBACK TO
4438: ROLLBACK TO CREATE_CU_WORKORDERS;
4439: x_return_status := fnd_api.g_ret_sts_error;
4440: --dbms_output.put_line('exzc');
4441:
4442: -- Get message count and data
4443: fnd_msg_pub.count_and_get
4444: ( p_count => x_msg_count
4445: , p_data => x_msg_data
4446: );
4447: --
4448: WHEN fnd_api.g_exc_unexpected_error THEN
4449: ROLLBACK TO CREATE_CU_WORKORDERS;
4450: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4451: --dbms_output.put_line('unex');
4452:
4446: );
4447: --
4448: WHEN fnd_api.g_exc_unexpected_error THEN
4449: ROLLBACK TO CREATE_CU_WORKORDERS;
4450: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4451: --dbms_output.put_line('unex');
4452:
4453: -- Get message count and data
4454: fnd_msg_pub.count_and_get
4456: , p_data => x_msg_data
4457: );
4458: --
4459: WHEN OTHERS THEN
4460: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4461: --dbms_output.put_line('others' || l_stmt_num);
4462: --
4463: ROLLBACK TO CREATE_CU_WORKORDERS;
4464: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4477: END CREATE_CU_WORKORDERS;
4478:
4479: procedure populate_WO(
4480: p_parent_wo IN NUMBER
4481: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4482: , p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4483: , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
4484: , x_return_status OUT NOCOPY VARCHAR2
4485: , x_msg_count OUT NOCOPY NUMBER
4495: BEGIN
4496:
4497: l_string := 'Inside' || G_PKG_NAME || '.Populate_WO';
4498:
4499: x_return_status := fnd_api.g_ret_sts_success;
4500:
4501: IF fnd_api.to_Boolean(p_init_msg_list) then
4502: fnd_msg_pub.initialize;
4503: end if;
4497: l_string := 'Inside' || G_PKG_NAME || '.Populate_WO';
4498:
4499: x_return_status := fnd_api.g_ret_sts_success;
4500:
4501: IF fnd_api.to_Boolean(p_init_msg_list) then
4502: fnd_msg_pub.initialize;
4503: end if;
4504:
4505: /* Is this the parent WO record */
4570:
4571: EXCEPTION
4572: WHEN OTHERS THEN
4573: DEBUG('Cannot find the item id');
4574: RAISE FND_API.g_exc_error;
4575: END;
4576:
4577: --Populate the failure entry record -- bug 7675526 Begin
4578:
4607: -- Print messages to log file
4608:
4609:
4610: EXCEPTION
4611: WHEN fnd_api.g_exc_error THEN
4612: x_return_status := fnd_api.g_ret_sts_error;
4613:
4614: -- Get message count and data
4615: fnd_msg_pub.count_and_get
4608:
4609:
4610: EXCEPTION
4611: WHEN fnd_api.g_exc_error THEN
4612: x_return_status := fnd_api.g_ret_sts_error;
4613:
4614: -- Get message count and data
4615: fnd_msg_pub.count_and_get
4616: ( p_count => x_msg_count
4616: ( p_count => x_msg_count
4617: , p_data => x_msg_data
4618: );
4619:
4620: WHEN fnd_api.g_exc_unexpected_error THEN
4621: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4622:
4623: -- Get message count and data
4624: fnd_msg_pub.count_and_get
4617: , p_data => x_msg_data
4618: );
4619:
4620: WHEN fnd_api.g_exc_unexpected_error THEN
4621: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4622:
4623: -- Get message count and data
4624: fnd_msg_pub.count_and_get
4625: ( p_count => x_msg_count
4626: , p_data => x_msg_data
4627: );
4628: --
4629: WHEN OTHERS THEN
4630: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4631: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4632: THEN
4633: fnd_msg_pub.add_exc_msg
4634: ( 'EAM_CONSTRUCTION_EST_PVT'
4647: END populate_WO;
4648:
4649: procedure POPULATE_OPERATION(
4650: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4651: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4652: , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type
4653: , x_return_status OUT NOCOPY VARCHAR2
4654: , x_msg_count OUT NOCOPY NUMBER
4655: , x_msg_data OUT NOCOPY VARCHAR2
4658: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
4659: l_stmt_num NUMBER := 0;
4660: BEGIN
4661:
4662: IF fnd_api.to_Boolean(p_init_msg_list) then
4663: fnd_msg_pub.initialize;
4664: end if;
4665:
4666: x_return_status := fnd_api.g_ret_sts_success;
4662: IF fnd_api.to_Boolean(p_init_msg_list) then
4663: fnd_msg_pub.initialize;
4664: end if;
4665:
4666: x_return_status := fnd_api.g_ret_sts_success;
4667:
4668: l_eam_op_rec := x_eam_op_rec;
4669:
4670: l_eam_op_rec.organization_id := p_ce_line_rec.organization_id;
4691: -- Print messages to log file
4692:
4693:
4694: EXCEPTION
4695: WHEN fnd_api.g_exc_error THEN
4696: x_return_status := fnd_api.g_ret_sts_error;
4697:
4698: -- Get message count and data
4699: fnd_msg_pub.count_and_get
4692:
4693:
4694: EXCEPTION
4695: WHEN fnd_api.g_exc_error THEN
4696: x_return_status := fnd_api.g_ret_sts_error;
4697:
4698: -- Get message count and data
4699: fnd_msg_pub.count_and_get
4700: ( p_count => x_msg_count
4700: ( p_count => x_msg_count
4701: , p_data => x_msg_data
4702: );
4703:
4704: WHEN fnd_api.g_exc_unexpected_error THEN
4705: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4706:
4707: -- Get message count and data
4708: fnd_msg_pub.count_and_get
4701: , p_data => x_msg_data
4702: );
4703:
4704: WHEN fnd_api.g_exc_unexpected_error THEN
4705: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4706:
4707: -- Get message count and data
4708: fnd_msg_pub.count_and_get
4709: ( p_count => x_msg_count
4710: , p_data => x_msg_data
4711: );
4712: --
4713: WHEN OTHERS THEN
4714: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4715: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_OPERATION: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4716: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4717: THEN
4718: fnd_msg_pub.add_exc_msg
4731: END POPULATE_OPERATION;
4732:
4733: procedure POPULATE_RESOURCE(
4734: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4735: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4736: , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type
4737: , x_return_status OUT NOCOPY VARCHAR2
4738: , x_msg_count OUT NOCOPY NUMBER
4739: , x_msg_data OUT NOCOPY VARCHAR2
4743: l_stmt_num NUMBER := 0;
4744: l_autocharge NUMBER;
4745: BEGIN
4746:
4747: IF fnd_api.to_Boolean(p_init_msg_list) then
4748: fnd_msg_pub.initialize;
4749: end if;
4750:
4751: x_return_status := fnd_api.g_ret_sts_success;
4747: IF fnd_api.to_Boolean(p_init_msg_list) then
4748: fnd_msg_pub.initialize;
4749: end if;
4750:
4751: x_return_status := fnd_api.g_ret_sts_success;
4752:
4753: l_eam_res_rec := x_eam_res_rec;
4754:
4755: l_eam_res_rec.organization_id := p_ce_line_rec.organization_id;
4800: -- Print messages to log file
4801:
4802:
4803: EXCEPTION
4804: WHEN fnd_api.g_exc_error THEN
4805: x_return_status := fnd_api.g_ret_sts_error;
4806:
4807: -- Get message count and data
4808: fnd_msg_pub.count_and_get
4801:
4802:
4803: EXCEPTION
4804: WHEN fnd_api.g_exc_error THEN
4805: x_return_status := fnd_api.g_ret_sts_error;
4806:
4807: -- Get message count and data
4808: fnd_msg_pub.count_and_get
4809: ( p_count => x_msg_count
4809: ( p_count => x_msg_count
4810: , p_data => x_msg_data
4811: );
4812:
4813: WHEN fnd_api.g_exc_unexpected_error THEN
4814: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4815:
4816: -- Get message count and data
4817: fnd_msg_pub.count_and_get
4810: , p_data => x_msg_data
4811: );
4812:
4813: WHEN fnd_api.g_exc_unexpected_error THEN
4814: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4815:
4816: -- Get message count and data
4817: fnd_msg_pub.count_and_get
4818: ( p_count => x_msg_count
4819: , p_data => x_msg_data
4820: );
4821: --
4822: WHEN OTHERS THEN
4823: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4824: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4826: THEN
4827: fnd_msg_pub.add_exc_msg
4840: END POPULATE_RESOURCE;
4841:
4842: procedure POPULATE_MATERIAL(
4843: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4844: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4845: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
4846: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
4847: , x_return_status OUT NOCOPY VARCHAR2
4848: , x_msg_count OUT NOCOPY NUMBER
4853: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
4854: l_stmt_num NUMBER := 0;
4855: BEGIN
4856:
4857: IF fnd_api.to_Boolean(p_init_msg_list) then
4858: fnd_msg_pub.initialize;
4859: end if;
4860:
4861: x_return_status := fnd_api.g_ret_sts_success;
4857: IF fnd_api.to_Boolean(p_init_msg_list) then
4858: fnd_msg_pub.initialize;
4859: end if;
4860:
4861: x_return_status := fnd_api.g_ret_sts_success;
4862:
4863: l_eam_mat_rec := x_eam_mat_rec;
4864: l_eam_direct_rec := x_eam_direct_rec;
4865:
4913: -- Print messages to log file
4914:
4915:
4916: EXCEPTION
4917: WHEN fnd_api.g_exc_error THEN
4918: x_return_status := fnd_api.g_ret_sts_error;
4919:
4920: -- Get message count and data
4921: fnd_msg_pub.count_and_get
4914:
4915:
4916: EXCEPTION
4917: WHEN fnd_api.g_exc_error THEN
4918: x_return_status := fnd_api.g_ret_sts_error;
4919:
4920: -- Get message count and data
4921: fnd_msg_pub.count_and_get
4922: ( p_count => x_msg_count
4922: ( p_count => x_msg_count
4923: , p_data => x_msg_data
4924: );
4925:
4926: WHEN fnd_api.g_exc_unexpected_error THEN
4927: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4928:
4929: -- Get message count and data
4930: fnd_msg_pub.count_and_get
4923: , p_data => x_msg_data
4924: );
4925:
4926: WHEN fnd_api.g_exc_unexpected_error THEN
4927: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4928:
4929: -- Get message count and data
4930: fnd_msg_pub.count_and_get
4931: ( p_count => x_msg_count
4932: , p_data => x_msg_data
4933: );
4934: --
4935: WHEN OTHERS THEN
4936: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4937: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4938: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4939: THEN
4940: fnd_msg_pub.add_exc_msg
5002: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
5003: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
5004: FND_MESSAGE.SET_TOKEN('VALUE', p_org_id);
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_ERROR;
5007: END IF;
5008:
5009: IF (p_src_estimate_id IS NULL) THEN
5010: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
5010: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
5011: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_ID');
5012: FND_MESSAGE.SET_TOKEN('VALUE', p_src_estimate_id);
5013: FND_MSG_PUB.ADD;
5014: RAISE FND_API.G_EXC_ERROR;
5015: END IF;
5016:
5017: -- Fetch the Estimates Cursor
5018: OPEN SRC_ESTIMATES_CUR;
5030: l_estimate_rec.ESTIMATE_DESCRIPTION := 'Copy of ' || l_estimate_rec.ESTIMATE_DESCRIPTION;
5031: END IF; -- l_estimate_rec.ESTIMATE_DESCRIPTION IS NULL
5032:
5033: IF NVL(l_estimate_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
5034: NVL(l_estimate_rec.PARENT_WO_ID,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5035: -- In this case the PARENT_WO_ID corresponds to the
5036: -- ESTIMATE_WORK_ORDER_LINE_ID in the ce work order lines table
5037: -- This parent information needs to be copied and updated
5038:
5041: l_estimate_rec.PARENT_WO_ID := NULL;
5042: l_estimate_rec.CREATE_PARENT_WO_FLAG := 'Y';
5043:
5044: ELSIF NVL(l_estimate_rec.CREATE_PARENT_WO_FLAG,'N') = 'N' AND
5045: NVL(l_estimate_rec.PARENT_WO_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
5046:
5047: l_estimate_rec.PARENT_WO_ID := NULL;
5048: l_estimate_rec.CREATE_PARENT_WO_FLAG := 'N';
5049:
5047: l_estimate_rec.PARENT_WO_ID := NULL;
5048: l_estimate_rec.CREATE_PARENT_WO_FLAG := 'N';
5049:
5050: ELSIF NVL(l_estimate_rec.CREATE_PARENT_WO_FLAG,'N') = 'N' AND
5051: NVL(l_estimate_rec.PARENT_WO_ID,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5052:
5053: -- l_estimate_rec.PARENT_WO_ID := NULL;
5054: l_estimate_rec.CREATE_PARENT_WO_FLAG := 'N';
5055:
5091: p_ATTRIBUTE14 => l_estimate_rec.attribute14,
5092: p_ATTRIBUTE15 => l_estimate_rec.attribute15
5093: );
5094:
5095: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
5096: -- Log error, but continue processing
5097: x_return_status := FND_API.G_RET_STS_ERROR;
5098: RAISE FND_API.G_EXC_ERROR;
5099: END IF; -- nvl(l_return_status,'S') <> 'S'
5093: );
5094:
5095: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
5096: -- Log error, but continue processing
5097: x_return_status := FND_API.G_RET_STS_ERROR;
5098: RAISE FND_API.G_EXC_ERROR;
5099: END IF; -- nvl(l_return_status,'S') <> 'S'
5100:
5101: -- Newly Copied Estimate ID
5094:
5095: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
5096: -- Log error, but continue processing
5097: x_return_status := FND_API.G_RET_STS_ERROR;
5098: RAISE FND_API.G_EXC_ERROR;
5099: END IF; -- nvl(l_return_status,'S') <> 'S'
5100:
5101: -- Newly Copied Estimate ID
5102: p_cpy_estimate_id := l_estimate_rec.ESTIMATE_ID;
5301:
5302: IF NVL(p_commit,'F') = 'T' THEN
5303: COMMIT;
5304: END IF;
5305: x_return_status := FND_API.G_RET_STS_SUCCESS;
5306:
5307: EXCEPTION
5308: WHEN FND_API.G_EXC_ERROR THEN
5309: ROLLBACK TO COPY_EST_WORKBENCH;
5304: END IF;
5305: x_return_status := FND_API.G_RET_STS_SUCCESS;
5306:
5307: EXCEPTION
5308: WHEN FND_API.G_EXC_ERROR THEN
5309: ROLLBACK TO COPY_EST_WORKBENCH;
5310: x_return_status := FND_API.G_RET_STS_ERROR;
5311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5312: p_data => x_msg_data);
5306:
5307: EXCEPTION
5308: WHEN FND_API.G_EXC_ERROR THEN
5309: ROLLBACK TO COPY_EST_WORKBENCH;
5310: x_return_status := FND_API.G_RET_STS_ERROR;
5311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5312: p_data => x_msg_data);
5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: ROLLBACK TO COPY_EST_WORKBENCH;
5309: ROLLBACK TO COPY_EST_WORKBENCH;
5310: x_return_status := FND_API.G_RET_STS_ERROR;
5311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5312: p_data => x_msg_data);
5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: ROLLBACK TO COPY_EST_WORKBENCH;
5315:
5316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5312: p_data => x_msg_data);
5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: ROLLBACK TO COPY_EST_WORKBENCH;
5315:
5316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5318: p_data => x_msg_data);
5319: WHEN OTHERS THEN
5320: ROLLBACK TO COPY_EST_WORKBENCH;
5317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5318: p_data => x_msg_data);
5319: WHEN OTHERS THEN
5320: ROLLBACK TO COPY_EST_WORKBENCH;
5321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5323: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'COPY_EST_WORKBENCH');
5324: END IF;
5325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,