[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;
209: IF nvl(l_return_status,'S') <> 'S' THEN
210: -- Log error, but continue processing
211: l_return_status := 'E';
212: debug('Error EXPLODE_CE_ACTIVITIES');
213: RAISE FND_API.G_EXC_ERROR;
214: END IF; -- nvl(l_return_status,'S') <> 'S'
215:
216: -- All the associated acitivites are exploeded and
217: -- available in l_out_eam_ce_wo_lines_tbl
218: -- Insert all the work order lines in to
219: -- EAM_CE_WORK_ORDER_LINES, but dont commit the data
220: INSERT_ALL_WO_LINES(
221: p_api_version => 1.0
222: , p_init_msg_list => FND_API.G_FALSE
223: , p_commit => p_commit
224: , p_estimate_id => l_estimate_id
225: , p_eam_ce_wo_lines_tbl => l_out_eam_ce_wo_lines_tbl
226: , x_return_status => l_return_status
231: IF nvl(l_return_status,'S') <> 'S' THEN
232: -- Log error, but continue processing
233: l_return_status := 'E';
234: debug('Error INSERT_ALL_WO_LINES');
235: RAISE FND_API.G_EXC_ERROR;
236: END IF; -- nvl(l_return_status,'S') <> 'S'
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238: debug ('End EXPLODE_INITIAL_ESTIMATE');
239: --COMMIT;
233: l_return_status := 'E';
234: debug('Error INSERT_ALL_WO_LINES');
235: RAISE FND_API.G_EXC_ERROR;
236: END IF; -- nvl(l_return_status,'S') <> 'S'
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238: debug ('End EXPLODE_INITIAL_ESTIMATE');
239: --COMMIT;
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238: debug ('End EXPLODE_INITIAL_ESTIMATE');
239: --COMMIT;
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
245: p_data => x_msg_data);
239: --COMMIT;
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
245: p_data => x_msg_data);
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
242: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
245: p_data => x_msg_data);
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
250: p_data => x_msg_data);
244: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
245: p_data => x_msg_data);
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
250: p_data => x_msg_data);
251: WHEN OTHERS THEN
252: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
250: p_data => x_msg_data);
251: WHEN OTHERS THEN
252: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
255: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_INITIAL_ESTIMATE');
256: END IF;
257: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
260: END EXPLODE_INITIAL_ESTIMATE;
261:
262: PROCEDURE DELETE_WO_LINE(
263: p_api_version IN NUMBER := 1.0
264: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
265: , p_commit IN VARCHAR2
266: , p_work_order_line_id IN NUMBER
267: , x_return_status OUT NOCOPY VARCHAR2
268: , x_msg_count OUT NOCOPY NUMBER
279: --FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
280: --FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
281: --FND_MESSAGE.SET_TOKEN('VALUE', p_parent_wo_line_rec.ORGANIZATION_ID);
282: --FND_MSG_PUB.ADD;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW(
287: p_work_order_line_id => p_work_order_line_id
293: END IF;
294: x_return_status := 'S';
295:
296: EXCEPTION
297: WHEN FND_API.G_EXC_ERROR THEN
298: ROLLBACK TO DELETE_WO_LINE;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
301: p_data => x_msg_data);
295:
296: EXCEPTION
297: WHEN FND_API.G_EXC_ERROR THEN
298: ROLLBACK TO DELETE_WO_LINE;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
301: p_data => x_msg_data);
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: ROLLBACK TO DELETE_WO_LINE;
298: ROLLBACK TO DELETE_WO_LINE;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
301: p_data => x_msg_data);
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: ROLLBACK TO DELETE_WO_LINE;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
306: p_data => x_msg_data);
300: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
301: p_data => x_msg_data);
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: ROLLBACK TO DELETE_WO_LINE;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
306: p_data => x_msg_data);
307: WHEN OTHERS THEN
308: ROLLBACK TO DELETE_WO_LINE;
305: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
306: p_data => x_msg_data);
307: WHEN OTHERS THEN
308: ROLLBACK TO DELETE_WO_LINE;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
311: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'DELETE_WO_LINE');
312: END IF;
313: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
315: END DELETE_WO_LINE;
316:
317: PROCEDURE INSERT_PARENT_WO_LINE(
318: p_api_version IN NUMBER := 1.0
319: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
320: , p_commit IN VARCHAR2
321: , p_estimate_id IN NUMBER
322: , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC
323: , x_return_status OUT NOCOPY VARCHAR2
358: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
359: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
360: FND_MESSAGE.SET_TOKEN('VALUE', p_parent_wo_line_rec.ORGANIZATION_ID);
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: IF (p_estimate_id IS NULL) THEN
366: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
366: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
367: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_NUMBER');
368: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_id);
369: FND_MSG_PUB.ADD;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: -- If the parent details already exist, update the estimate
374: OPEN EST_PARENT_CSR;
380: -- and parent work order number
381: -- Construct estimate rec with the parent wo details
382: l_estimate_rec.ESTIMATE_ID := p_estimate_id;
383: l_estimate_rec.ORGANIZATION_ID := p_parent_wo_line_rec.ORGANIZATION_ID;
384: l_estimate_rec.ESTIMATE_NUMBER := FND_API.G_MISS_CHAR;
385: l_estimate_rec.ESTIMATE_DESCRIPTION := FND_API.G_MISS_CHAR;
386: l_estimate_rec.GROUPING_OPTION := FND_API.G_MISS_NUM;
387:
388: -- If the create parent flag is Y then the
381: -- Construct estimate rec with the parent wo details
382: l_estimate_rec.ESTIMATE_ID := p_estimate_id;
383: l_estimate_rec.ORGANIZATION_ID := p_parent_wo_line_rec.ORGANIZATION_ID;
384: l_estimate_rec.ESTIMATE_NUMBER := FND_API.G_MISS_CHAR;
385: l_estimate_rec.ESTIMATE_DESCRIPTION := FND_API.G_MISS_CHAR;
386: l_estimate_rec.GROUPING_OPTION := FND_API.G_MISS_NUM;
387:
388: -- If the create parent flag is Y then the
389: -- PARENT_WO_ID holds the ESTIMATE_WORK_ORDER_LINE_ID
382: l_estimate_rec.ESTIMATE_ID := p_estimate_id;
383: l_estimate_rec.ORGANIZATION_ID := p_parent_wo_line_rec.ORGANIZATION_ID;
384: l_estimate_rec.ESTIMATE_NUMBER := FND_API.G_MISS_CHAR;
385: l_estimate_rec.ESTIMATE_DESCRIPTION := FND_API.G_MISS_CHAR;
386: l_estimate_rec.GROUPING_OPTION := FND_API.G_MISS_NUM;
387:
388: -- If the create parent flag is Y then the
389: -- PARENT_WO_ID holds the ESTIMATE_WORK_ORDER_LINE_ID
390: -- CE work order lines table
395: -- PARENT_WO_ID holds ESTIMATE_WORK_ORDER_LINE_ID
396: -- The the corresponding ESTIMATE_WORK_ORDER_LINE_ID contains all the
397: -- parent work order details
398:
399: IF NVL(l_estimate_parent_rec.PARENT_WO_ID,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
400: AND NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') <> 'N' THEN
401:
402: l_wo_line_id_seq := l_estimate_parent_rec.PARENT_WO_ID;
403:
402: l_wo_line_id_seq := l_estimate_parent_rec.PARENT_WO_ID;
403:
404: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
405: p_estimate_work_order_line_id => l_wo_line_id_seq
406: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
407: ,p_src_cu_id => FND_API.G_MISS_NUM
408: ,p_src_activity_id => FND_API.G_MISS_NUM
409: ,p_src_activity_qty => FND_API.G_MISS_NUM
410: ,p_src_op_seq_num => FND_API.G_MISS_NUM
403:
404: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
405: p_estimate_work_order_line_id => l_wo_line_id_seq
406: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
407: ,p_src_cu_id => FND_API.G_MISS_NUM
408: ,p_src_activity_id => FND_API.G_MISS_NUM
409: ,p_src_activity_qty => FND_API.G_MISS_NUM
410: ,p_src_op_seq_num => FND_API.G_MISS_NUM
411: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
404: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
405: p_estimate_work_order_line_id => l_wo_line_id_seq
406: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
407: ,p_src_cu_id => FND_API.G_MISS_NUM
408: ,p_src_activity_id => FND_API.G_MISS_NUM
409: ,p_src_activity_qty => FND_API.G_MISS_NUM
410: ,p_src_op_seq_num => FND_API.G_MISS_NUM
411: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
412: ,p_src_diff_id => FND_API.G_MISS_NUM
405: p_estimate_work_order_line_id => l_wo_line_id_seq
406: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
407: ,p_src_cu_id => FND_API.G_MISS_NUM
408: ,p_src_activity_id => FND_API.G_MISS_NUM
409: ,p_src_activity_qty => FND_API.G_MISS_NUM
410: ,p_src_op_seq_num => FND_API.G_MISS_NUM
411: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
412: ,p_src_diff_id => FND_API.G_MISS_NUM
413: ,p_diff_qty => FND_API.G_MISS_NUM
406: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
407: ,p_src_cu_id => FND_API.G_MISS_NUM
408: ,p_src_activity_id => FND_API.G_MISS_NUM
409: ,p_src_activity_qty => FND_API.G_MISS_NUM
410: ,p_src_op_seq_num => FND_API.G_MISS_NUM
411: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
412: ,p_src_diff_id => FND_API.G_MISS_NUM
413: ,p_diff_qty => FND_API.G_MISS_NUM
414: ,p_estimate_id => p_estimate_id
407: ,p_src_cu_id => FND_API.G_MISS_NUM
408: ,p_src_activity_id => FND_API.G_MISS_NUM
409: ,p_src_activity_qty => FND_API.G_MISS_NUM
410: ,p_src_op_seq_num => FND_API.G_MISS_NUM
411: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
412: ,p_src_diff_id => FND_API.G_MISS_NUM
413: ,p_diff_qty => FND_API.G_MISS_NUM
414: ,p_estimate_id => p_estimate_id
415: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
408: ,p_src_activity_id => FND_API.G_MISS_NUM
409: ,p_src_activity_qty => FND_API.G_MISS_NUM
410: ,p_src_op_seq_num => FND_API.G_MISS_NUM
411: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
412: ,p_src_diff_id => FND_API.G_MISS_NUM
413: ,p_diff_qty => FND_API.G_MISS_NUM
414: ,p_estimate_id => p_estimate_id
415: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
416: ,p_work_order_seq_num => FND_API.G_MISS_NUM
409: ,p_src_activity_qty => FND_API.G_MISS_NUM
410: ,p_src_op_seq_num => FND_API.G_MISS_NUM
411: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
412: ,p_src_diff_id => FND_API.G_MISS_NUM
413: ,p_diff_qty => FND_API.G_MISS_NUM
414: ,p_estimate_id => p_estimate_id
415: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
416: ,p_work_order_seq_num => FND_API.G_MISS_NUM
417: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
412: ,p_src_diff_id => FND_API.G_MISS_NUM
413: ,p_diff_qty => FND_API.G_MISS_NUM
414: ,p_estimate_id => p_estimate_id
415: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
416: ,p_work_order_seq_num => FND_API.G_MISS_NUM
417: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
418: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
419: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
420: ,p_primary_item_id => FND_API.G_MISS_NUM
415: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
416: ,p_work_order_seq_num => FND_API.G_MISS_NUM
417: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
418: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
419: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
420: ,p_primary_item_id => FND_API.G_MISS_NUM
421: ,p_status_type => FND_API.G_MISS_NUM
422: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
423: ,p_scheduled_start_date => sysdate
416: ,p_work_order_seq_num => FND_API.G_MISS_NUM
417: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
418: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
419: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
420: ,p_primary_item_id => FND_API.G_MISS_NUM
421: ,p_status_type => FND_API.G_MISS_NUM
422: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
423: ,p_scheduled_start_date => sysdate
424: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
417: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
418: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
419: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
420: ,p_primary_item_id => FND_API.G_MISS_NUM
421: ,p_status_type => FND_API.G_MISS_NUM
422: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
423: ,p_scheduled_start_date => sysdate
424: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
425: ,p_project_id => p_parent_wo_line_rec.PROJECT_ID
420: ,p_primary_item_id => FND_API.G_MISS_NUM
421: ,p_status_type => FND_API.G_MISS_NUM
422: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
423: ,p_scheduled_start_date => sysdate
424: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
425: ,p_project_id => p_parent_wo_line_rec.PROJECT_ID
426: ,p_task_id => p_parent_wo_line_rec.TASK_ID
427: ,p_maintenance_object_id => p_parent_wo_line_rec.MAINTENANCE_OBJECT_ID
428: ,p_maintenance_object_type => p_parent_wo_line_rec.MAINTENANCE_OBJECT_TYPE
428: ,p_maintenance_object_type => p_parent_wo_line_rec.MAINTENANCE_OBJECT_TYPE
429: ,p_maintenance_object_source => p_parent_wo_line_rec.MAINTENANCE_OBJECT_SOURCE
430: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
431: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
432: ,p_op_seq_num => FND_API.G_MISS_NUM
433: ,p_op_description => FND_API.G_MISS_CHAR
434: ,p_standard_operation_id => FND_API.G_MISS_NUM
435: ,p_op_department_id => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
429: ,p_maintenance_object_source => p_parent_wo_line_rec.MAINTENANCE_OBJECT_SOURCE
430: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
431: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
432: ,p_op_seq_num => FND_API.G_MISS_NUM
433: ,p_op_description => FND_API.G_MISS_CHAR
434: ,p_standard_operation_id => FND_API.G_MISS_NUM
435: ,p_op_department_id => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
437: ,p_res_seq_num => FND_API.G_MISS_NUM
430: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
431: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
432: ,p_op_seq_num => FND_API.G_MISS_NUM
433: ,p_op_description => FND_API.G_MISS_CHAR
434: ,p_standard_operation_id => FND_API.G_MISS_NUM
435: ,p_op_department_id => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
437: ,p_res_seq_num => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM
431: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
432: ,p_op_seq_num => FND_API.G_MISS_NUM
433: ,p_op_description => FND_API.G_MISS_CHAR
434: ,p_standard_operation_id => FND_API.G_MISS_NUM
435: ,p_op_department_id => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
437: ,p_res_seq_num => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM
439: ,p_res_uom => FND_API.G_MISS_CHAR
432: ,p_op_seq_num => FND_API.G_MISS_NUM
433: ,p_op_description => FND_API.G_MISS_CHAR
434: ,p_standard_operation_id => FND_API.G_MISS_NUM
435: ,p_op_department_id => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
437: ,p_res_seq_num => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM
439: ,p_res_uom => FND_API.G_MISS_CHAR
440: ,p_res_basis_type => FND_API.G_MISS_NUM
433: ,p_op_description => FND_API.G_MISS_CHAR
434: ,p_standard_operation_id => FND_API.G_MISS_NUM
435: ,p_op_department_id => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
437: ,p_res_seq_num => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM
439: ,p_res_uom => FND_API.G_MISS_CHAR
440: ,p_res_basis_type => FND_API.G_MISS_NUM
441: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
434: ,p_standard_operation_id => FND_API.G_MISS_NUM
435: ,p_op_department_id => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
437: ,p_res_seq_num => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM
439: ,p_res_uom => FND_API.G_MISS_CHAR
440: ,p_res_basis_type => FND_API.G_MISS_NUM
441: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
442: ,p_res_required_units => FND_API.G_MISS_NUM
435: ,p_op_department_id => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
437: ,p_res_seq_num => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM
439: ,p_res_uom => FND_API.G_MISS_CHAR
440: ,p_res_basis_type => FND_API.G_MISS_NUM
441: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
442: ,p_res_required_units => FND_API.G_MISS_NUM
443: ,p_res_assigned_units => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
437: ,p_res_seq_num => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM
439: ,p_res_uom => FND_API.G_MISS_CHAR
440: ,p_res_basis_type => FND_API.G_MISS_NUM
441: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
442: ,p_res_required_units => FND_API.G_MISS_NUM
443: ,p_res_assigned_units => FND_API.G_MISS_NUM
444: ,p_item_type => FND_API.G_MISS_NUM
437: ,p_res_seq_num => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM
439: ,p_res_uom => FND_API.G_MISS_CHAR
440: ,p_res_basis_type => FND_API.G_MISS_NUM
441: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
442: ,p_res_required_units => FND_API.G_MISS_NUM
443: ,p_res_assigned_units => FND_API.G_MISS_NUM
444: ,p_item_type => FND_API.G_MISS_NUM
445: ,p_required_quantity => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM
439: ,p_res_uom => FND_API.G_MISS_CHAR
440: ,p_res_basis_type => FND_API.G_MISS_NUM
441: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
442: ,p_res_required_units => FND_API.G_MISS_NUM
443: ,p_res_assigned_units => FND_API.G_MISS_NUM
444: ,p_item_type => FND_API.G_MISS_NUM
445: ,p_required_quantity => FND_API.G_MISS_NUM
446: ,p_unit_price => FND_API.G_MISS_NUM
439: ,p_res_uom => FND_API.G_MISS_CHAR
440: ,p_res_basis_type => FND_API.G_MISS_NUM
441: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
442: ,p_res_required_units => FND_API.G_MISS_NUM
443: ,p_res_assigned_units => FND_API.G_MISS_NUM
444: ,p_item_type => FND_API.G_MISS_NUM
445: ,p_required_quantity => FND_API.G_MISS_NUM
446: ,p_unit_price => FND_API.G_MISS_NUM
447: ,p_uom => FND_API.G_MISS_CHAR
440: ,p_res_basis_type => FND_API.G_MISS_NUM
441: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
442: ,p_res_required_units => FND_API.G_MISS_NUM
443: ,p_res_assigned_units => FND_API.G_MISS_NUM
444: ,p_item_type => FND_API.G_MISS_NUM
445: ,p_required_quantity => FND_API.G_MISS_NUM
446: ,p_unit_price => FND_API.G_MISS_NUM
447: ,p_uom => FND_API.G_MISS_CHAR
448: ,p_basis_type => FND_API.G_MISS_NUM
441: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
442: ,p_res_required_units => FND_API.G_MISS_NUM
443: ,p_res_assigned_units => FND_API.G_MISS_NUM
444: ,p_item_type => FND_API.G_MISS_NUM
445: ,p_required_quantity => FND_API.G_MISS_NUM
446: ,p_unit_price => FND_API.G_MISS_NUM
447: ,p_uom => FND_API.G_MISS_CHAR
448: ,p_basis_type => FND_API.G_MISS_NUM
449: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
442: ,p_res_required_units => FND_API.G_MISS_NUM
443: ,p_res_assigned_units => FND_API.G_MISS_NUM
444: ,p_item_type => FND_API.G_MISS_NUM
445: ,p_required_quantity => FND_API.G_MISS_NUM
446: ,p_unit_price => FND_API.G_MISS_NUM
447: ,p_uom => FND_API.G_MISS_CHAR
448: ,p_basis_type => FND_API.G_MISS_NUM
449: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
450: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
443: ,p_res_assigned_units => FND_API.G_MISS_NUM
444: ,p_item_type => FND_API.G_MISS_NUM
445: ,p_required_quantity => FND_API.G_MISS_NUM
446: ,p_unit_price => FND_API.G_MISS_NUM
447: ,p_uom => FND_API.G_MISS_CHAR
448: ,p_basis_type => FND_API.G_MISS_NUM
449: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
450: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
451: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
444: ,p_item_type => FND_API.G_MISS_NUM
445: ,p_required_quantity => FND_API.G_MISS_NUM
446: ,p_unit_price => FND_API.G_MISS_NUM
447: ,p_uom => FND_API.G_MISS_CHAR
448: ,p_basis_type => FND_API.G_MISS_NUM
449: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
450: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
451: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
452: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
445: ,p_required_quantity => FND_API.G_MISS_NUM
446: ,p_unit_price => FND_API.G_MISS_NUM
447: ,p_uom => FND_API.G_MISS_CHAR
448: ,p_basis_type => FND_API.G_MISS_NUM
449: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
450: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
451: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
452: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
453: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
446: ,p_unit_price => FND_API.G_MISS_NUM
447: ,p_uom => FND_API.G_MISS_CHAR
448: ,p_basis_type => FND_API.G_MISS_NUM
449: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
450: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
451: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
452: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
453: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
454: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
447: ,p_uom => FND_API.G_MISS_CHAR
448: ,p_basis_type => FND_API.G_MISS_NUM
449: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
450: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
451: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
452: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
453: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
454: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
455: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
448: ,p_basis_type => FND_API.G_MISS_NUM
449: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
450: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
451: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
452: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
453: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
454: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
455: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
456: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
449: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
450: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
451: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
452: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
453: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
454: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
455: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
456: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
457: ,p_di_amount => FND_API.G_MISS_NUM
450: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
451: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
452: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
453: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
454: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
455: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
456: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
457: ,p_di_amount => FND_API.G_MISS_NUM
458: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
451: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
452: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
453: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
454: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
455: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
456: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
457: ,p_di_amount => FND_API.G_MISS_NUM
458: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
459: ,p_di_description => FND_API.G_MISS_CHAR
452: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
453: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
454: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
455: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
456: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
457: ,p_di_amount => FND_API.G_MISS_NUM
458: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
459: ,p_di_description => FND_API.G_MISS_CHAR
460: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
453: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
454: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
455: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
456: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
457: ,p_di_amount => FND_API.G_MISS_NUM
458: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
459: ,p_di_description => FND_API.G_MISS_CHAR
460: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
461: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
454: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
455: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
456: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
457: ,p_di_amount => FND_API.G_MISS_NUM
458: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
459: ,p_di_description => FND_API.G_MISS_CHAR
460: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
461: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
462: ,p_di_need_by_date => FND_API.G_MISS_DATE
455: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
456: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
457: ,p_di_amount => FND_API.G_MISS_NUM
458: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
459: ,p_di_description => FND_API.G_MISS_CHAR
460: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
461: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
462: ,p_di_need_by_date => FND_API.G_MISS_DATE
463: ,p_work_order_line_cost => FND_API.G_MISS_NUM
456: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
457: ,p_di_amount => FND_API.G_MISS_NUM
458: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
459: ,p_di_description => FND_API.G_MISS_CHAR
460: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
461: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
462: ,p_di_need_by_date => FND_API.G_MISS_DATE
463: ,p_work_order_line_cost => FND_API.G_MISS_NUM
464: ,p_creation_date => sysdate
457: ,p_di_amount => FND_API.G_MISS_NUM
458: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
459: ,p_di_description => FND_API.G_MISS_CHAR
460: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
461: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
462: ,p_di_need_by_date => FND_API.G_MISS_DATE
463: ,p_work_order_line_cost => FND_API.G_MISS_NUM
464: ,p_creation_date => sysdate
465: ,p_created_by => FND_GLOBAL.LOGIN_ID
458: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
459: ,p_di_description => FND_API.G_MISS_CHAR
460: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
461: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
462: ,p_di_need_by_date => FND_API.G_MISS_DATE
463: ,p_work_order_line_cost => FND_API.G_MISS_NUM
464: ,p_creation_date => sysdate
465: ,p_created_by => FND_GLOBAL.LOGIN_ID
466: ,p_last_update_date => sysdate
459: ,p_di_description => FND_API.G_MISS_CHAR
460: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
461: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
462: ,p_di_need_by_date => FND_API.G_MISS_DATE
463: ,p_work_order_line_cost => FND_API.G_MISS_NUM
464: ,p_creation_date => sysdate
465: ,p_created_by => FND_GLOBAL.LOGIN_ID
466: ,p_last_update_date => sysdate
467: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
465: ,p_created_by => FND_GLOBAL.LOGIN_ID
466: ,p_last_update_date => sysdate
467: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
468: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
469: ,p_work_order_type => FND_API.G_MISS_NUM
470: ,p_activity_type => FND_API.G_MISS_NUM
471: ,p_activity_source => FND_API.G_MISS_NUM
472: ,p_activity_cause => FND_API.G_MISS_NUM
473: ,p_available_qty => FND_API.G_MISS_NUM
466: ,p_last_update_date => sysdate
467: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
468: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
469: ,p_work_order_type => FND_API.G_MISS_NUM
470: ,p_activity_type => FND_API.G_MISS_NUM
471: ,p_activity_source => FND_API.G_MISS_NUM
472: ,p_activity_cause => FND_API.G_MISS_NUM
473: ,p_available_qty => FND_API.G_MISS_NUM
474: ,p_item_comments => FND_API.G_MISS_CHAR
467: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
468: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
469: ,p_work_order_type => FND_API.G_MISS_NUM
470: ,p_activity_type => FND_API.G_MISS_NUM
471: ,p_activity_source => FND_API.G_MISS_NUM
472: ,p_activity_cause => FND_API.G_MISS_NUM
473: ,p_available_qty => FND_API.G_MISS_NUM
474: ,p_item_comments => FND_API.G_MISS_CHAR
475: ,p_cu_qty => FND_API.G_MISS_NUM
468: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
469: ,p_work_order_type => FND_API.G_MISS_NUM
470: ,p_activity_type => FND_API.G_MISS_NUM
471: ,p_activity_source => FND_API.G_MISS_NUM
472: ,p_activity_cause => FND_API.G_MISS_NUM
473: ,p_available_qty => FND_API.G_MISS_NUM
474: ,p_item_comments => FND_API.G_MISS_CHAR
475: ,p_cu_qty => FND_API.G_MISS_NUM
476: ,p_res_sch_flag => FND_API.G_MISS_NUM
469: ,p_work_order_type => FND_API.G_MISS_NUM
470: ,p_activity_type => FND_API.G_MISS_NUM
471: ,p_activity_source => FND_API.G_MISS_NUM
472: ,p_activity_cause => FND_API.G_MISS_NUM
473: ,p_available_qty => FND_API.G_MISS_NUM
474: ,p_item_comments => FND_API.G_MISS_CHAR
475: ,p_cu_qty => FND_API.G_MISS_NUM
476: ,p_res_sch_flag => FND_API.G_MISS_NUM
477: );
470: ,p_activity_type => FND_API.G_MISS_NUM
471: ,p_activity_source => FND_API.G_MISS_NUM
472: ,p_activity_cause => FND_API.G_MISS_NUM
473: ,p_available_qty => FND_API.G_MISS_NUM
474: ,p_item_comments => FND_API.G_MISS_CHAR
475: ,p_cu_qty => FND_API.G_MISS_NUM
476: ,p_res_sch_flag => FND_API.G_MISS_NUM
477: );
478:
471: ,p_activity_source => FND_API.G_MISS_NUM
472: ,p_activity_cause => FND_API.G_MISS_NUM
473: ,p_available_qty => FND_API.G_MISS_NUM
474: ,p_item_comments => FND_API.G_MISS_CHAR
475: ,p_cu_qty => FND_API.G_MISS_NUM
476: ,p_res_sch_flag => FND_API.G_MISS_NUM
477: );
478:
479: ELSE
472: ,p_activity_cause => FND_API.G_MISS_NUM
473: ,p_available_qty => FND_API.G_MISS_NUM
474: ,p_item_comments => FND_API.G_MISS_CHAR
475: ,p_cu_qty => FND_API.G_MISS_NUM
476: ,p_res_sch_flag => FND_API.G_MISS_NUM
477: );
478:
479: ELSE
480:
481: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
482:
483: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
484: p_estimate_work_order_line_id => l_wo_line_id_seq
485: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
486: ,p_src_cu_id => FND_API.G_MISS_NUM
487: ,p_src_activity_id => FND_API.G_MISS_NUM
488: ,p_src_activity_qty => FND_API.G_MISS_NUM
489: ,p_src_op_seq_num => FND_API.G_MISS_NUM
482:
483: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
484: p_estimate_work_order_line_id => l_wo_line_id_seq
485: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
486: ,p_src_cu_id => FND_API.G_MISS_NUM
487: ,p_src_activity_id => FND_API.G_MISS_NUM
488: ,p_src_activity_qty => FND_API.G_MISS_NUM
489: ,p_src_op_seq_num => FND_API.G_MISS_NUM
490: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
483: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
484: p_estimate_work_order_line_id => l_wo_line_id_seq
485: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
486: ,p_src_cu_id => FND_API.G_MISS_NUM
487: ,p_src_activity_id => FND_API.G_MISS_NUM
488: ,p_src_activity_qty => FND_API.G_MISS_NUM
489: ,p_src_op_seq_num => FND_API.G_MISS_NUM
490: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
491: ,p_src_diff_id => FND_API.G_MISS_NUM
484: p_estimate_work_order_line_id => l_wo_line_id_seq
485: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
486: ,p_src_cu_id => FND_API.G_MISS_NUM
487: ,p_src_activity_id => FND_API.G_MISS_NUM
488: ,p_src_activity_qty => FND_API.G_MISS_NUM
489: ,p_src_op_seq_num => FND_API.G_MISS_NUM
490: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
491: ,p_src_diff_id => FND_API.G_MISS_NUM
492: ,p_diff_qty => FND_API.G_MISS_NUM
485: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
486: ,p_src_cu_id => FND_API.G_MISS_NUM
487: ,p_src_activity_id => FND_API.G_MISS_NUM
488: ,p_src_activity_qty => FND_API.G_MISS_NUM
489: ,p_src_op_seq_num => FND_API.G_MISS_NUM
490: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
491: ,p_src_diff_id => FND_API.G_MISS_NUM
492: ,p_diff_qty => FND_API.G_MISS_NUM
493: ,p_estimate_id => p_estimate_id
486: ,p_src_cu_id => FND_API.G_MISS_NUM
487: ,p_src_activity_id => FND_API.G_MISS_NUM
488: ,p_src_activity_qty => FND_API.G_MISS_NUM
489: ,p_src_op_seq_num => FND_API.G_MISS_NUM
490: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
491: ,p_src_diff_id => FND_API.G_MISS_NUM
492: ,p_diff_qty => FND_API.G_MISS_NUM
493: ,p_estimate_id => p_estimate_id
494: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
487: ,p_src_activity_id => FND_API.G_MISS_NUM
488: ,p_src_activity_qty => FND_API.G_MISS_NUM
489: ,p_src_op_seq_num => FND_API.G_MISS_NUM
490: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
491: ,p_src_diff_id => FND_API.G_MISS_NUM
492: ,p_diff_qty => FND_API.G_MISS_NUM
493: ,p_estimate_id => p_estimate_id
494: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
495: ,p_work_order_seq_num => FND_API.G_MISS_NUM
488: ,p_src_activity_qty => FND_API.G_MISS_NUM
489: ,p_src_op_seq_num => FND_API.G_MISS_NUM
490: ,p_src_acct_class_code => FND_API.G_MISS_CHAR
491: ,p_src_diff_id => FND_API.G_MISS_NUM
492: ,p_diff_qty => FND_API.G_MISS_NUM
493: ,p_estimate_id => p_estimate_id
494: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
495: ,p_work_order_seq_num => FND_API.G_MISS_NUM
496: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
491: ,p_src_diff_id => FND_API.G_MISS_NUM
492: ,p_diff_qty => FND_API.G_MISS_NUM
493: ,p_estimate_id => p_estimate_id
494: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
495: ,p_work_order_seq_num => FND_API.G_MISS_NUM
496: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
497: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
498: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
499: ,p_primary_item_id => FND_API.G_MISS_NUM
494: ,p_organization_id => p_parent_wo_line_rec.ORGANIZATION_ID
495: ,p_work_order_seq_num => FND_API.G_MISS_NUM
496: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
497: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
498: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
499: ,p_primary_item_id => FND_API.G_MISS_NUM
500: ,p_status_type => FND_API.G_MISS_NUM
501: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
502: ,p_scheduled_start_date => sysdate
495: ,p_work_order_seq_num => FND_API.G_MISS_NUM
496: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
497: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
498: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
499: ,p_primary_item_id => FND_API.G_MISS_NUM
500: ,p_status_type => FND_API.G_MISS_NUM
501: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
502: ,p_scheduled_start_date => sysdate
503: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
496: ,p_work_order_number => p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER
497: ,p_work_order_description => p_parent_wo_line_rec.WORK_ORDER_DESCRIPTION
498: ,p_ref_wip_entity_id => FND_API.G_MISS_NUM
499: ,p_primary_item_id => FND_API.G_MISS_NUM
500: ,p_status_type => FND_API.G_MISS_NUM
501: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
502: ,p_scheduled_start_date => sysdate
503: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
504: ,p_project_id => p_parent_wo_line_rec.PROJECT_ID
499: ,p_primary_item_id => FND_API.G_MISS_NUM
500: ,p_status_type => FND_API.G_MISS_NUM
501: ,p_acct_class_code => p_parent_wo_line_rec.ACCT_CLASS_CODE
502: ,p_scheduled_start_date => sysdate
503: ,p_scheduled_completion_date => FND_API.G_MISS_DATE
504: ,p_project_id => p_parent_wo_line_rec.PROJECT_ID
505: ,p_task_id => p_parent_wo_line_rec.TASK_ID
506: ,p_maintenance_object_id => p_parent_wo_line_rec.MAINTENANCE_OBJECT_ID
507: ,p_maintenance_object_type => p_parent_wo_line_rec.MAINTENANCE_OBJECT_TYPE
507: ,p_maintenance_object_type => p_parent_wo_line_rec.MAINTENANCE_OBJECT_TYPE
508: ,p_maintenance_object_source => p_parent_wo_line_rec.MAINTENANCE_OBJECT_SOURCE
509: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
510: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
511: ,p_op_seq_num => FND_API.G_MISS_NUM
512: ,p_op_description => FND_API.G_MISS_CHAR
513: ,p_standard_operation_id => FND_API.G_MISS_NUM
514: ,p_op_department_id => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
508: ,p_maintenance_object_source => p_parent_wo_line_rec.MAINTENANCE_OBJECT_SOURCE
509: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
510: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
511: ,p_op_seq_num => FND_API.G_MISS_NUM
512: ,p_op_description => FND_API.G_MISS_CHAR
513: ,p_standard_operation_id => FND_API.G_MISS_NUM
514: ,p_op_department_id => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
516: ,p_res_seq_num => FND_API.G_MISS_NUM
509: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
510: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
511: ,p_op_seq_num => FND_API.G_MISS_NUM
512: ,p_op_description => FND_API.G_MISS_CHAR
513: ,p_standard_operation_id => FND_API.G_MISS_NUM
514: ,p_op_department_id => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
516: ,p_res_seq_num => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM
510: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
511: ,p_op_seq_num => FND_API.G_MISS_NUM
512: ,p_op_description => FND_API.G_MISS_CHAR
513: ,p_standard_operation_id => FND_API.G_MISS_NUM
514: ,p_op_department_id => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
516: ,p_res_seq_num => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM
518: ,p_res_uom => FND_API.G_MISS_CHAR
511: ,p_op_seq_num => FND_API.G_MISS_NUM
512: ,p_op_description => FND_API.G_MISS_CHAR
513: ,p_standard_operation_id => FND_API.G_MISS_NUM
514: ,p_op_department_id => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
516: ,p_res_seq_num => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM
518: ,p_res_uom => FND_API.G_MISS_CHAR
519: ,p_res_basis_type => FND_API.G_MISS_NUM
512: ,p_op_description => FND_API.G_MISS_CHAR
513: ,p_standard_operation_id => FND_API.G_MISS_NUM
514: ,p_op_department_id => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
516: ,p_res_seq_num => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM
518: ,p_res_uom => FND_API.G_MISS_CHAR
519: ,p_res_basis_type => FND_API.G_MISS_NUM
520: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
513: ,p_standard_operation_id => FND_API.G_MISS_NUM
514: ,p_op_department_id => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
516: ,p_res_seq_num => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM
518: ,p_res_uom => FND_API.G_MISS_CHAR
519: ,p_res_basis_type => FND_API.G_MISS_NUM
520: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
521: ,p_res_required_units => FND_API.G_MISS_NUM
514: ,p_op_department_id => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
516: ,p_res_seq_num => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM
518: ,p_res_uom => FND_API.G_MISS_CHAR
519: ,p_res_basis_type => FND_API.G_MISS_NUM
520: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
521: ,p_res_required_units => FND_API.G_MISS_NUM
522: ,p_res_assigned_units => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
516: ,p_res_seq_num => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM
518: ,p_res_uom => FND_API.G_MISS_CHAR
519: ,p_res_basis_type => FND_API.G_MISS_NUM
520: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
521: ,p_res_required_units => FND_API.G_MISS_NUM
522: ,p_res_assigned_units => FND_API.G_MISS_NUM
523: ,p_item_type => FND_API.G_MISS_NUM
516: ,p_res_seq_num => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM
518: ,p_res_uom => FND_API.G_MISS_CHAR
519: ,p_res_basis_type => FND_API.G_MISS_NUM
520: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
521: ,p_res_required_units => FND_API.G_MISS_NUM
522: ,p_res_assigned_units => FND_API.G_MISS_NUM
523: ,p_item_type => FND_API.G_MISS_NUM
524: ,p_required_quantity => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM
518: ,p_res_uom => FND_API.G_MISS_CHAR
519: ,p_res_basis_type => FND_API.G_MISS_NUM
520: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
521: ,p_res_required_units => FND_API.G_MISS_NUM
522: ,p_res_assigned_units => FND_API.G_MISS_NUM
523: ,p_item_type => FND_API.G_MISS_NUM
524: ,p_required_quantity => FND_API.G_MISS_NUM
525: ,p_unit_price => FND_API.G_MISS_NUM
518: ,p_res_uom => FND_API.G_MISS_CHAR
519: ,p_res_basis_type => FND_API.G_MISS_NUM
520: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
521: ,p_res_required_units => FND_API.G_MISS_NUM
522: ,p_res_assigned_units => FND_API.G_MISS_NUM
523: ,p_item_type => FND_API.G_MISS_NUM
524: ,p_required_quantity => FND_API.G_MISS_NUM
525: ,p_unit_price => FND_API.G_MISS_NUM
526: ,p_uom => FND_API.G_MISS_CHAR
519: ,p_res_basis_type => FND_API.G_MISS_NUM
520: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
521: ,p_res_required_units => FND_API.G_MISS_NUM
522: ,p_res_assigned_units => FND_API.G_MISS_NUM
523: ,p_item_type => FND_API.G_MISS_NUM
524: ,p_required_quantity => FND_API.G_MISS_NUM
525: ,p_unit_price => FND_API.G_MISS_NUM
526: ,p_uom => FND_API.G_MISS_CHAR
527: ,p_basis_type => FND_API.G_MISS_NUM
520: ,p_res_usage_rate_or_amount => FND_API.G_MISS_NUM
521: ,p_res_required_units => FND_API.G_MISS_NUM
522: ,p_res_assigned_units => FND_API.G_MISS_NUM
523: ,p_item_type => FND_API.G_MISS_NUM
524: ,p_required_quantity => FND_API.G_MISS_NUM
525: ,p_unit_price => FND_API.G_MISS_NUM
526: ,p_uom => FND_API.G_MISS_CHAR
527: ,p_basis_type => FND_API.G_MISS_NUM
528: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
521: ,p_res_required_units => FND_API.G_MISS_NUM
522: ,p_res_assigned_units => FND_API.G_MISS_NUM
523: ,p_item_type => FND_API.G_MISS_NUM
524: ,p_required_quantity => FND_API.G_MISS_NUM
525: ,p_unit_price => FND_API.G_MISS_NUM
526: ,p_uom => FND_API.G_MISS_CHAR
527: ,p_basis_type => FND_API.G_MISS_NUM
528: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
529: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
522: ,p_res_assigned_units => FND_API.G_MISS_NUM
523: ,p_item_type => FND_API.G_MISS_NUM
524: ,p_required_quantity => FND_API.G_MISS_NUM
525: ,p_unit_price => FND_API.G_MISS_NUM
526: ,p_uom => FND_API.G_MISS_CHAR
527: ,p_basis_type => FND_API.G_MISS_NUM
528: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
529: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
530: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
523: ,p_item_type => FND_API.G_MISS_NUM
524: ,p_required_quantity => FND_API.G_MISS_NUM
525: ,p_unit_price => FND_API.G_MISS_NUM
526: ,p_uom => FND_API.G_MISS_CHAR
527: ,p_basis_type => FND_API.G_MISS_NUM
528: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
529: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
530: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
531: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
524: ,p_required_quantity => FND_API.G_MISS_NUM
525: ,p_unit_price => FND_API.G_MISS_NUM
526: ,p_uom => FND_API.G_MISS_CHAR
527: ,p_basis_type => FND_API.G_MISS_NUM
528: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
529: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
530: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
531: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
532: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
525: ,p_unit_price => FND_API.G_MISS_NUM
526: ,p_uom => FND_API.G_MISS_CHAR
527: ,p_basis_type => FND_API.G_MISS_NUM
528: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
529: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
530: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
531: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
532: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
533: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
526: ,p_uom => FND_API.G_MISS_CHAR
527: ,p_basis_type => FND_API.G_MISS_NUM
528: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
529: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
530: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
531: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
532: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
533: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
534: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
527: ,p_basis_type => FND_API.G_MISS_NUM
528: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
529: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
530: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
531: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
532: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
533: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
534: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
535: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
528: ,p_suggested_vendor_name => FND_API.G_MISS_CHAR
529: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
530: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
531: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
532: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
533: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
534: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
535: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
536: ,p_di_amount => FND_API.G_MISS_NUM
529: ,p_suggested_vendor_id => FND_API.G_MISS_NUM
530: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
531: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
532: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
533: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
534: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
535: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
536: ,p_di_amount => FND_API.G_MISS_NUM
537: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
530: ,p_suggested_vendor_site => FND_API.G_MISS_CHAR
531: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
532: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
533: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
534: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
535: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
536: ,p_di_amount => FND_API.G_MISS_NUM
537: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
538: ,p_di_description => FND_API.G_MISS_CHAR
531: ,p_suggested_vendor_site_id => FND_API.G_MISS_NUM
532: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
533: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
534: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
535: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
536: ,p_di_amount => FND_API.G_MISS_NUM
537: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
538: ,p_di_description => FND_API.G_MISS_CHAR
539: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
532: ,p_mat_inventory_item_id => FND_API.G_MISS_NUM
533: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
534: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
535: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
536: ,p_di_amount => FND_API.G_MISS_NUM
537: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
538: ,p_di_description => FND_API.G_MISS_CHAR
539: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
540: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
533: ,p_mat_component_seq_num => FND_API.G_MISS_NUM
534: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
535: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
536: ,p_di_amount => FND_API.G_MISS_NUM
537: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
538: ,p_di_description => FND_API.G_MISS_CHAR
539: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
540: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
541: ,p_di_need_by_date => FND_API.G_MISS_DATE
534: ,p_mat_supply_subinventory => FND_API.G_MISS_CHAR
535: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
536: ,p_di_amount => FND_API.G_MISS_NUM
537: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
538: ,p_di_description => FND_API.G_MISS_CHAR
539: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
540: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
541: ,p_di_need_by_date => FND_API.G_MISS_DATE
542: ,p_work_order_line_cost => FND_API.G_MISS_NUM
535: ,p_mat_supply_locator_id => FND_API.G_MISS_NUM
536: ,p_di_amount => FND_API.G_MISS_NUM
537: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
538: ,p_di_description => FND_API.G_MISS_CHAR
539: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
540: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
541: ,p_di_need_by_date => FND_API.G_MISS_DATE
542: ,p_work_order_line_cost => FND_API.G_MISS_NUM
543: ,p_creation_date => sysdate
536: ,p_di_amount => FND_API.G_MISS_NUM
537: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
538: ,p_di_description => FND_API.G_MISS_CHAR
539: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
540: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
541: ,p_di_need_by_date => FND_API.G_MISS_DATE
542: ,p_work_order_line_cost => FND_API.G_MISS_NUM
543: ,p_creation_date => sysdate
544: ,p_created_by => FND_GLOBAL.LOGIN_ID
537: ,p_di_order_type_lookup_code => FND_API.G_MISS_CHAR
538: ,p_di_description => FND_API.G_MISS_CHAR
539: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
540: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
541: ,p_di_need_by_date => FND_API.G_MISS_DATE
542: ,p_work_order_line_cost => FND_API.G_MISS_NUM
543: ,p_creation_date => sysdate
544: ,p_created_by => FND_GLOBAL.LOGIN_ID
545: ,p_last_update_date => sysdate
538: ,p_di_description => FND_API.G_MISS_CHAR
539: ,p_di_purchase_category_id => FND_API.G_MISS_NUM
540: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
541: ,p_di_need_by_date => FND_API.G_MISS_DATE
542: ,p_work_order_line_cost => FND_API.G_MISS_NUM
543: ,p_creation_date => sysdate
544: ,p_created_by => FND_GLOBAL.LOGIN_ID
545: ,p_last_update_date => sysdate
546: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
544: ,p_created_by => FND_GLOBAL.LOGIN_ID
545: ,p_last_update_date => sysdate
546: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
547: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
548: ,p_work_order_type => FND_API.G_MISS_NUM
549: ,p_activity_type => FND_API.G_MISS_NUM
550: ,p_activity_source => FND_API.G_MISS_NUM
551: ,p_activity_cause => FND_API.G_MISS_NUM
552: ,p_available_qty => FND_API.G_MISS_NUM
545: ,p_last_update_date => sysdate
546: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
547: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
548: ,p_work_order_type => FND_API.G_MISS_NUM
549: ,p_activity_type => FND_API.G_MISS_NUM
550: ,p_activity_source => FND_API.G_MISS_NUM
551: ,p_activity_cause => FND_API.G_MISS_NUM
552: ,p_available_qty => FND_API.G_MISS_NUM
553: ,p_item_comments => FND_API.G_MISS_CHAR
546: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
547: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
548: ,p_work_order_type => FND_API.G_MISS_NUM
549: ,p_activity_type => FND_API.G_MISS_NUM
550: ,p_activity_source => FND_API.G_MISS_NUM
551: ,p_activity_cause => FND_API.G_MISS_NUM
552: ,p_available_qty => FND_API.G_MISS_NUM
553: ,p_item_comments => FND_API.G_MISS_CHAR
554: ,p_cu_qty => FND_API.G_MISS_NUM
547: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
548: ,p_work_order_type => FND_API.G_MISS_NUM
549: ,p_activity_type => FND_API.G_MISS_NUM
550: ,p_activity_source => FND_API.G_MISS_NUM
551: ,p_activity_cause => FND_API.G_MISS_NUM
552: ,p_available_qty => FND_API.G_MISS_NUM
553: ,p_item_comments => FND_API.G_MISS_CHAR
554: ,p_cu_qty => FND_API.G_MISS_NUM
555: ,p_res_sch_flag => FND_API.G_MISS_NUM
548: ,p_work_order_type => FND_API.G_MISS_NUM
549: ,p_activity_type => FND_API.G_MISS_NUM
550: ,p_activity_source => FND_API.G_MISS_NUM
551: ,p_activity_cause => FND_API.G_MISS_NUM
552: ,p_available_qty => FND_API.G_MISS_NUM
553: ,p_item_comments => FND_API.G_MISS_CHAR
554: ,p_cu_qty => FND_API.G_MISS_NUM
555: ,p_res_sch_flag => FND_API.G_MISS_NUM
556: );
549: ,p_activity_type => FND_API.G_MISS_NUM
550: ,p_activity_source => FND_API.G_MISS_NUM
551: ,p_activity_cause => FND_API.G_MISS_NUM
552: ,p_available_qty => FND_API.G_MISS_NUM
553: ,p_item_comments => FND_API.G_MISS_CHAR
554: ,p_cu_qty => FND_API.G_MISS_NUM
555: ,p_res_sch_flag => FND_API.G_MISS_NUM
556: );
557:
550: ,p_activity_source => FND_API.G_MISS_NUM
551: ,p_activity_cause => FND_API.G_MISS_NUM
552: ,p_available_qty => FND_API.G_MISS_NUM
553: ,p_item_comments => FND_API.G_MISS_CHAR
554: ,p_cu_qty => FND_API.G_MISS_NUM
555: ,p_res_sch_flag => FND_API.G_MISS_NUM
556: );
557:
558:
551: ,p_activity_cause => FND_API.G_MISS_NUM
552: ,p_available_qty => FND_API.G_MISS_NUM
553: ,p_item_comments => FND_API.G_MISS_CHAR
554: ,p_cu_qty => FND_API.G_MISS_NUM
555: ,p_res_sch_flag => FND_API.G_MISS_NUM
556: );
557:
558:
559: END IF; -- IF l_estimate_parent_rec.PARENT_WO_ID IS NULL THEN
592: );
593:
594: ELSE
595:
596: IF nvl(p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
597: -- p_parent_wo_line_rec.CREATE_PARENT_FLAG is 'N' the PARENT_WORK_ORDER_NUMBER is
598: -- existing wip entity id
599: -- Update the estimates table with the wip entity id (PARENT_WORK_ORDER_NUMBER)
600: -- of the existing work order
635:
636: -- If the create work order flag has been switched from Y to N
637: -- then delete the work order line created when the flag was Y
638: IF NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
639: NVL(l_estimate_parent_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
640: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (
641: p_work_order_line_id => l_estimate_parent_rec.PARENT_WO_ID
642: );
643: END IF; -- NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y'
675: p_ATTRIBUTE15 => l_estimate_rec.attribute15
676: );
677:
678: IF NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
679: NVL(l_estimate_parent_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
680: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (
681: p_work_order_line_id => l_estimate_parent_rec.PARENT_WO_ID
682: );
683: END IF;
688: COMMIT;
689: END IF;
690: x_return_status := 'S';
691: EXCEPTION
692: WHEN FND_API.G_EXC_ERROR THEN
693: ROLLBACK TO INSERT_PARENT_WO_LINE;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
696: p_data => x_msg_data);
690: x_return_status := 'S';
691: EXCEPTION
692: WHEN FND_API.G_EXC_ERROR THEN
693: ROLLBACK TO INSERT_PARENT_WO_LINE;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
696: p_data => x_msg_data);
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: ROLLBACK TO INSERT_PARENT_WO_LINE;
693: ROLLBACK TO INSERT_PARENT_WO_LINE;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
696: p_data => x_msg_data);
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: ROLLBACK TO INSERT_PARENT_WO_LINE;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
701: p_data => x_msg_data);
695: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
696: p_data => x_msg_data);
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: ROLLBACK TO INSERT_PARENT_WO_LINE;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
701: p_data => x_msg_data);
702: WHEN OTHERS THEN
703: ROLLBACK TO INSERT_PARENT_WO_LINE;
700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
701: p_data => x_msg_data);
702: WHEN OTHERS THEN
703: ROLLBACK TO INSERT_PARENT_WO_LINE;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
706: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_PARENT_WO_LINE');
707: END IF;
708: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
798:
799:
800: FOR std_op_rec IN STD_OP_RES_CUR LOOP
801:
802: IF NVL(std_op_rec.RESOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
803: -- Calculate Cost
804: GET_UNIT_RESOURCE_COST(
805: p_resource_id => std_op_rec.RESOURCE_ID
806: , p_cost_type_id => l_cost_type_id
812:
813: IF nvl(x_return_status,'S') <> 'S' THEN
814: -- Log error, but continue processing
815: x_return_status := 'E';
816: RAISE FND_API.G_EXC_ERROR;
817: END IF; -- nvl(l_return_status,'S') <> 'S'
818: END IF;
819:
820: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
821: -- to insert wo line row
822:
823: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
824: p_estimate_work_order_line_id => NULL
825: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
826: ,p_src_cu_id => NULL
827: ,p_src_activity_id => NULL
828: ,p_src_activity_qty => NULL
829: ,p_src_op_seq_num => NULL
897:
898: END LOOP; -- FOR std_op_rec IN STD_OP_RES_CUR LOOP
899: x_return_status := 'S';
900: EXCEPTION
901: WHEN FND_API.G_EXC_ERROR THEN
902: --ROLLBACK TO EXPLODE_STD_OP;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
905: p_data => x_msg_data);
899: x_return_status := 'S';
900: EXCEPTION
901: WHEN FND_API.G_EXC_ERROR THEN
902: --ROLLBACK TO EXPLODE_STD_OP;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
905: p_data => x_msg_data);
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: -- ROLLBACK TO EXPLODE_STD_OP;
902: --ROLLBACK TO EXPLODE_STD_OP;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
905: p_data => x_msg_data);
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: -- ROLLBACK TO EXPLODE_STD_OP;
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
910: p_data => x_msg_data);
904: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
905: p_data => x_msg_data);
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: -- ROLLBACK TO EXPLODE_STD_OP;
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
910: p_data => x_msg_data);
911: WHEN OTHERS THEN
912: -- ROLLBACK TO EXPLODE_STD_OP;
909: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
910: p_data => x_msg_data);
911: WHEN OTHERS THEN
912: -- ROLLBACK TO EXPLODE_STD_OP;
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
915: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_STD_OP');
916: END IF;
917: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
920:
921:
922: PROCEDURE INSERT_ALL_WO_LINES(
923: p_api_version IN NUMBER := 1.0
924: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
925: , p_commit IN VARCHAR2
926: , p_estimate_id IN NUMBER
927: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
928: , x_return_status OUT NOCOPY VARCHAR2
1018:
1019: IF p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID IS NOT NULL THEN
1020:
1021: -- If the resource is modified the cost needs to be calcuated again
1022: 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
1023: -- Calculate Cost
1024: GET_UNIT_RESOURCE_COST(
1025: p_resource_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID
1026: , p_cost_type_id => l_cost_type_id
1032:
1033: IF nvl(l_return_status,'S') <> 'S' THEN
1034: -- Log error, but continue processing
1035: x_return_status := 'E';
1036: RAISE FND_API.G_EXC_ERROR;
1037: END IF; -- nvl(l_return_status,'S') <> 'S'
1038: END IF;
1039:
1040: -- Get the system status from user defined status id
1049:
1050: -- Call UPDATE_ROW TO update the changes
1051: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
1052: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID
1053: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
1054: ,p_src_cu_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_CU_ID
1055: ,p_src_activity_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_ID
1056: ,p_src_activity_qty => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_QTY
1057: ,p_src_op_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_OP_SEQ_NUM
1128: -- Assigning unit cost before recalculating
1129: l_unit_cost := p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_LINE_COST;
1130:
1131: -- If the resource is modified the cost needs to be calcuated again
1132: 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
1133: -- Calculate Cost
1134: GET_UNIT_RESOURCE_COST(
1135: p_resource_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID
1136: , p_cost_type_id => l_cost_type_id
1142:
1143: IF nvl(l_return_status,'S') <> 'S' THEN
1144: -- Log error, but continue processing
1145: x_return_status := 'E';
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF; -- nvl(l_return_status,'S') <> 'S'
1148: END IF;
1149:
1150: -- Get the system status from user defined status id
1161: -- to insert wo line row
1162:
1163: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
1164: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID
1165: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
1166: ,p_src_cu_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_CU_ID
1167: ,p_src_activity_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_ID
1168: ,p_src_activity_qty => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_QTY
1169: ,p_src_op_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_OP_SEQ_NUM
1243: COMMIT;
1244: END IF;
1245: x_return_status := 'S';
1246: EXCEPTION
1247: WHEN FND_API.G_EXC_ERROR THEN
1248: ROLLBACK TO INSERT_ALL_WO_LINES;
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1251: p_data => x_msg_data);
1245: x_return_status := 'S';
1246: EXCEPTION
1247: WHEN FND_API.G_EXC_ERROR THEN
1248: ROLLBACK TO INSERT_ALL_WO_LINES;
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1251: p_data => x_msg_data);
1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: ROLLBACK TO INSERT_ALL_WO_LINES;
1248: ROLLBACK TO INSERT_ALL_WO_LINES;
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1251: p_data => x_msg_data);
1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: ROLLBACK TO INSERT_ALL_WO_LINES;
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1256: p_data => x_msg_data);
1250: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1251: p_data => x_msg_data);
1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: ROLLBACK TO INSERT_ALL_WO_LINES;
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1256: p_data => x_msg_data);
1257: WHEN OTHERS THEN
1258: ROLLBACK TO INSERT_ALL_WO_LINES;
1255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1256: p_data => x_msg_data);
1257: WHEN OTHERS THEN
1258: ROLLBACK TO INSERT_ALL_WO_LINES;
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1261: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_ALL_WO_LINES');
1262: END IF;
1263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1316: WHERE ESTIMATE_ID = p_estimate_id;
1317:
1318: BEGIN
1319: INIT_DEBUG(
1320: p_init_msg_list => FND_API.G_TRUE,
1321: p_debug_filename => l_debug_filename,
1322: p_debug_file_mode => 'w',
1323: p_debug => l_debug);
1324:
1356: l_eam_mat_req_tbl := INIT_EAM_MAT_REQ_TBL_TYPE;
1357:
1358: -- Calling EAM_EXPLODE_ACTIVITY_PVT.EXPLODE_ACTIVITY to explode the activities
1359: EAM_EXPLODE_ACTIVITY_PVT.EXPLODE_ACTIVITY
1360: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL
1361: , p_eam_wo_rec => l_eam_wo_rec
1362: , p_eam_op_tbl => l_eam_op_tbl
1363: , p_eam_op_network_tbl => l_eam_op_network_tbl
1364: , p_eam_res_tbl => l_eam_res_tbl
1584:
1585: IF nvl(l_return_status,'S') <> 'S' THEN
1586: -- Log error, but continue processing
1587: x_return_status := 'E';
1588: RAISE FND_API.G_EXC_ERROR;
1589: END IF; -- nvl(l_return_status,'S') <> 'S'
1590:
1591: --l_wo_ind := l_wo_ind + 1;
1592: END IF; -- p_eam_res_tbl(l_res_index).OPERATION_SEQ_NUM = p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM
1692:
1693: IF nvl(l_return_status,'S') <> 'S' THEN
1694: -- Log error, but continue processing
1695: x_return_status := 'E';
1696: RAISE FND_API.G_EXC_ERROR;
1697: END IF; -- nvl(l_return_status,'S') <> 'S'
1698:
1699: --l_wo_ind := l_wo_ind + 1;
1700: END IF; --p_eam_mat_req_tbl(l_mat_index).OPERATION_SEQ_NUM = p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM
1738: -- Copy the output table
1739: x_eam_ce_wo_lines_tbl := l_eam_ce_wo_lines_tbl;
1740:
1741: EXCEPTION
1742: WHEN FND_API.G_EXC_ERROR THEN
1743: x_return_status := 'E';
1744: debug('In to FND_API.G_EXC_ERROR in POPULATE_CE_WORK_ORDER_LINES');
1745: WHEN OTHERS THEN
1746: x_return_status := 'E';
1740:
1741: EXCEPTION
1742: WHEN FND_API.G_EXC_ERROR THEN
1743: x_return_status := 'E';
1744: debug('In to FND_API.G_EXC_ERROR in POPULATE_CE_WORK_ORDER_LINES');
1745: WHEN OTHERS THEN
1746: x_return_status := 'E';
1747: debug('In to Others exception in POPULATE_CE_WORK_ORDER_LINES');
1748: END POPULATE_CE_WORK_ORDER_LINES;
1815: l_index NUMBER := 0;
1816: BEGIN
1817: SAVEPOINT GET_CU_RECS;
1818:
1819: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1821: END IF;
1822:
1823: --Initialize message list if p_init_msg_list is set to TRUE.
1816: BEGIN
1817: SAVEPOINT GET_CU_RECS;
1818:
1819: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1821: END IF;
1822:
1823: --Initialize message list if p_init_msg_list is set to TRUE.
1824: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1821: END IF;
1822:
1823: --Initialize message list if p_init_msg_list is set to TRUE.
1824: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1825: FND_MSG_PUB.INITIALIZE;
1826: END IF;
1827:
1828: --Initialize API return status to success
1825: FND_MSG_PUB.INITIALIZE;
1826: END IF;
1827:
1828: --Initialize API return status to success
1829: x_return_status := FND_API.G_RET_STS_SUCCESS;
1830:
1831: INIT_DEBUG(
1832: p_init_msg_list => p_init_msg_list,
1833: p_debug_filename => l_debug_filename,
1877: WHEN OTHERS THEN
1878: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CU_ID');
1879: FND_MESSAGE.SET_TOKEN('CU_ID', px_cu_tbl(l_index).CU_ID);
1880: FND_MSG_PUB.ADD;
1881: RAISE FND_API.G_EXC_ERROR;
1882: END;
1883: END LOOP;
1884: END IF;
1885: EXCEPTION
1882: END;
1883: END LOOP;
1884: END IF;
1885: EXCEPTION
1886: WHEN FND_API.G_EXC_ERROR THEN
1887: ROLLBACK TO GET_CU_RECS;
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1890: p_count => x_msg_count,
1884: END IF;
1885: EXCEPTION
1886: WHEN FND_API.G_EXC_ERROR THEN
1887: ROLLBACK TO GET_CU_RECS;
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1890: p_count => x_msg_count,
1891: p_data => x_msg_data);
1892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1890: p_count => x_msg_count,
1891: p_data => x_msg_data);
1892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1893: ROLLBACK TO GET_CU_RECS;
1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1895: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1896: p_count => x_msg_count,
1890: p_count => x_msg_count,
1891: p_data => x_msg_data);
1892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1893: ROLLBACK TO GET_CU_RECS;
1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1895: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1896: p_count => x_msg_count,
1897: p_data => x_msg_data);
1898: WHEN OTHERS THEN
1896: p_count => x_msg_count,
1897: p_data => x_msg_data);
1898: WHEN OTHERS THEN
1899: ROLLBACK TO GET_CU_RECS;
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1901: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1902: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1903: END IF;
1904: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1940: l_activities_rec EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC;
1941: BEGIN
1942: SAVEPOINT GET_CU_ACTIVITIES;
1943:
1944: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1946: END IF;
1947:
1948: --Initialize message list if p_init_msg_list is set to TRUE.
1941: BEGIN
1942: SAVEPOINT GET_CU_ACTIVITIES;
1943:
1944: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1946: END IF;
1947:
1948: --Initialize message list if p_init_msg_list is set to TRUE.
1949: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1946: END IF;
1947:
1948: --Initialize message list if p_init_msg_list is set to TRUE.
1949: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1950: FND_MSG_PUB.INITIALIZE;
1951: END IF;
1952:
1953: --Initialize API return status to success
1950: FND_MSG_PUB.INITIALIZE;
1951: END IF;
1952:
1953: --Initialize API return status to success
1954: x_return_status := FND_API.G_RET_STS_SUCCESS;
1955:
1956: INIT_DEBUG(
1957: p_init_msg_list => p_init_msg_list,
1958: p_debug_filename => l_debug_filename,
2031: DEBUG('x_return_status : ' || x_return_status);
2032: DEBUG('x_msg_count : ' || x_msg_count);
2033: END IF;
2034: EXCEPTION
2035: WHEN FND_API.G_EXC_ERROR THEN
2036: ROLLBACK TO GET_CU_ACTIVITIES;
2037: x_return_status := FND_API.G_RET_STS_ERROR;
2038: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2039: p_count => x_msg_count,
2033: END IF;
2034: EXCEPTION
2035: WHEN FND_API.G_EXC_ERROR THEN
2036: ROLLBACK TO GET_CU_ACTIVITIES;
2037: x_return_status := FND_API.G_RET_STS_ERROR;
2038: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2039: p_count => x_msg_count,
2040: p_data => x_msg_data);
2041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2037: x_return_status := FND_API.G_RET_STS_ERROR;
2038: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2039: p_count => x_msg_count,
2040: p_data => x_msg_data);
2041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2042: ROLLBACK TO GET_CU_ACTIVITIES;
2043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2044: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2045: p_count => x_msg_count,
2039: p_count => x_msg_count,
2040: p_data => x_msg_data);
2041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2042: ROLLBACK TO GET_CU_ACTIVITIES;
2043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2044: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2045: p_count => x_msg_count,
2046: p_data => x_msg_data);
2047: WHEN OTHERS THEN
2045: p_count => x_msg_count,
2046: p_data => x_msg_data);
2047: WHEN OTHERS THEN
2048: ROLLBACK TO GET_CU_ACTIVITIES;
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2050: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2051: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2052: END IF;
2053: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2078: l_estimate_exist VARCHAR2(1) := 'N';
2079: BEGIN
2080: SAVEPOINT CREATE_ESTIMATE;
2081:
2082: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END IF;
2085:
2086: --Initialize message list if p_init_msg_list is set to TRUE.
2079: BEGIN
2080: SAVEPOINT CREATE_ESTIMATE;
2081:
2082: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END IF;
2085:
2086: --Initialize message list if p_init_msg_list is set to TRUE.
2087: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END IF;
2085:
2086: --Initialize message list if p_init_msg_list is set to TRUE.
2087: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2088: FND_MSG_PUB.INITIALIZE;
2089: END IF;
2090:
2091: --Initialize API return status to success
2088: FND_MSG_PUB.INITIALIZE;
2089: END IF;
2090:
2091: --Initialize API return status to success
2092: x_return_status := FND_API.G_RET_STS_SUCCESS;
2093:
2094: INIT_DEBUG(
2095: p_init_msg_list => p_init_msg_list,
2096: p_debug_filename => l_debug_filename,
2116: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2117: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
2118: FND_MESSAGE.SET_TOKEN('VALUE', px_estimate_rec.ORGANIZATION_ID);
2119: FND_MSG_PUB.ADD;
2120: RAISE FND_API.G_EXC_ERROR;
2121: END IF;
2122:
2123: IF (px_estimate_rec.ESTIMATE_NUMBER IS NULL) THEN
2124: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2124: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2125: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_NUMBER');
2126: FND_MESSAGE.SET_TOKEN('VALUE', px_estimate_rec.ESTIMATE_NUMBER);
2127: FND_MSG_PUB.ADD;
2128: RAISE FND_API.G_EXC_ERROR;
2129: ELSE
2130: BEGIN
2131: SELECT 'Y'
2132: INTO l_estimate_exist
2140: IF l_estimate_exist = 'Y' THEN
2141: FND_MESSAGE.SET_NAME('EAM','EAM_ESTIMATE_NAME_UNIQUE');
2142: FND_MESSAGE.SET_TOKEN('ESTIMATE_NAME', px_estimate_rec.ESTIMATE_NUMBER);
2143: FND_MSG_PUB.ADD;
2144: RAISE FND_API.G_EXC_ERROR;
2145: END IF;
2146: END IF;
2147:
2148: EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW(
2179: IF (l_debug = 'Y') THEN
2180: DEBUG('Created estimate with ID : ' || px_estimate_rec.ESTIMATE_ID);
2181: END IF;
2182:
2183: IF (p_commit = FND_API.G_TRUE) THEN
2184: COMMIT;
2185: END IF;
2186:
2187: IF (l_debug = 'Y') THEN
2188: DEBUG('x_return_status : ' || x_return_status);
2189: DEBUG('x_msg_count : ' || x_msg_count);
2190: END IF;
2191: EXCEPTION
2192: WHEN FND_API.G_EXC_ERROR THEN
2193: ROLLBACK TO CREATE_ESTIMATE;
2194: x_return_status := FND_API.G_RET_STS_ERROR;
2195: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2196: p_count => x_msg_count,
2190: END IF;
2191: EXCEPTION
2192: WHEN FND_API.G_EXC_ERROR THEN
2193: ROLLBACK TO CREATE_ESTIMATE;
2194: x_return_status := FND_API.G_RET_STS_ERROR;
2195: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2196: p_count => x_msg_count,
2197: p_data => x_msg_data);
2198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2194: x_return_status := FND_API.G_RET_STS_ERROR;
2195: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2196: p_count => x_msg_count,
2197: p_data => x_msg_data);
2198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2199: ROLLBACK TO CREATE_ESTIMATE;
2200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2201: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2202: p_count => x_msg_count,
2196: p_count => x_msg_count,
2197: p_data => x_msg_data);
2198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2199: ROLLBACK TO CREATE_ESTIMATE;
2200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2201: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2202: p_count => x_msg_count,
2203: p_data => x_msg_data);
2204: WHEN OTHERS THEN
2202: p_count => x_msg_count,
2203: p_data => x_msg_data);
2204: WHEN OTHERS THEN
2205: ROLLBACK TO CREATE_ESTIMATE;
2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2208: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2209: END IF;
2210: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2232: l_last_updated_date DATE := SYSDATE;
2233: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2234: l_last_updated_login NUMBER;
2235: l_estimate_exist VARCHAR2(1) := 'N';
2236: l_parent_creation_flag VARCHAR(1) := FND_API.G_MISS_CHAR;
2237: l_parent_wo_id NUMBER := FND_API.G_MISS_NUM;
2238:
2239: BEGIN
2240: SAVEPOINT UPDATE_ESTIMATE;
2233: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2234: l_last_updated_login NUMBER;
2235: l_estimate_exist VARCHAR2(1) := 'N';
2236: l_parent_creation_flag VARCHAR(1) := FND_API.G_MISS_CHAR;
2237: l_parent_wo_id NUMBER := FND_API.G_MISS_NUM;
2238:
2239: BEGIN
2240: SAVEPOINT UPDATE_ESTIMATE;
2241:
2238:
2239: BEGIN
2240: SAVEPOINT UPDATE_ESTIMATE;
2241:
2242: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2244: END IF;
2245:
2246: --Initialize message list if p_init_msg_list is set to TRUE.
2239: BEGIN
2240: SAVEPOINT UPDATE_ESTIMATE;
2241:
2242: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2244: END IF;
2245:
2246: --Initialize message list if p_init_msg_list is set to TRUE.
2247: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2244: END IF;
2245:
2246: --Initialize message list if p_init_msg_list is set to TRUE.
2247: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2248: FND_MSG_PUB.INITIALIZE;
2249: END IF;
2250:
2251: --Initialize API return status to success
2248: FND_MSG_PUB.INITIALIZE;
2249: END IF;
2250:
2251: --Initialize API return status to success
2252: x_return_status := FND_API.G_RET_STS_SUCCESS;
2253:
2254: INIT_DEBUG(
2255: p_init_msg_list => p_init_msg_list,
2256: p_debug_filename => l_debug_filename,
2276: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2277: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_ID');
2278: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_rec.ESTIMATE_ID);
2279: FND_MSG_PUB.ADD;
2280: RAISE FND_API.G_EXC_ERROR;
2281: END IF;
2282:
2283: IF (p_estimate_rec.ORGANIZATION_ID IS NULL) THEN
2284: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2284: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2285: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
2286: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_rec.ORGANIZATION_ID);
2287: FND_MSG_PUB.ADD;
2288: RAISE FND_API.G_EXC_ERROR;
2289: END IF;
2290:
2291: IF (p_estimate_rec.ESTIMATE_NUMBER IS NULL) THEN
2292: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2292: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2293: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_NUMBER');
2294: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_rec.ESTIMATE_NUMBER);
2295: FND_MSG_PUB.ADD;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSE
2298: BEGIN
2299: SELECT 'Y'
2300: INTO l_estimate_exist
2309: IF l_estimate_exist = 'Y' THEN
2310: FND_MESSAGE.SET_NAME('EAM','EAM_ESTIMATE_NAME_UNIQUE');
2311: FND_MESSAGE.SET_TOKEN('ESTIMATE_NAME', p_estimate_rec.ESTIMATE_NUMBER);
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.G_EXC_ERROR;
2314: END IF;
2315: END IF;
2316:
2317: -- Verifying data
2314: END IF;
2315: END IF;
2316:
2317: -- Verifying data
2318: IF NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM OR
2319: p_estimate_rec.PARENT_WO_ID IS NOT NULL THEN
2320: l_parent_wo_id := p_estimate_rec.PARENT_WO_ID;
2321: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2322:
2317: -- Verifying data
2318: IF NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM OR
2319: p_estimate_rec.PARENT_WO_ID IS NOT NULL THEN
2320: l_parent_wo_id := p_estimate_rec.PARENT_WO_ID;
2321: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2322:
2323: IF NVL(p_estimate_rec.CREATE_PARENT_WO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR OR
2324: p_estimate_rec.CREATE_PARENT_WO_FLAG IS NOT NULL THEN
2325: l_parent_creation_flag := p_estimate_rec.CREATE_PARENT_WO_FLAG;
2319: p_estimate_rec.PARENT_WO_ID IS NOT NULL THEN
2320: l_parent_wo_id := p_estimate_rec.PARENT_WO_ID;
2321: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2322:
2323: IF NVL(p_estimate_rec.CREATE_PARENT_WO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR OR
2324: p_estimate_rec.CREATE_PARENT_WO_FLAG IS NOT NULL THEN
2325: l_parent_creation_flag := p_estimate_rec.CREATE_PARENT_WO_FLAG;
2326: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2327:
2322:
2323: IF NVL(p_estimate_rec.CREATE_PARENT_WO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR OR
2324: p_estimate_rec.CREATE_PARENT_WO_FLAG IS NOT NULL THEN
2325: l_parent_creation_flag := p_estimate_rec.CREATE_PARENT_WO_FLAG;
2326: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2327:
2328:
2329: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
2330: p_ESTIMATE_ID => p_estimate_rec.ESTIMATE_ID,
2360: IF (l_debug = 'Y') THEN
2361: DEBUG('Update estimate with ID : ' || p_estimate_rec.ESTIMATE_ID);
2362: END IF;
2363:
2364: IF (p_commit = FND_API.G_TRUE) THEN
2365: COMMIT;
2366: END IF;
2367:
2368: IF (l_debug = 'Y') THEN
2369: DEBUG('x_return_status : ' || x_return_status);
2370: DEBUG('x_msg_count : ' || x_msg_count);
2371: END IF;
2372: EXCEPTION
2373: WHEN FND_API.G_EXC_ERROR THEN
2374: ROLLBACK TO UPDATE_ESTIMATE;
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2377: p_count => x_msg_count,
2371: END IF;
2372: EXCEPTION
2373: WHEN FND_API.G_EXC_ERROR THEN
2374: ROLLBACK TO UPDATE_ESTIMATE;
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2377: p_count => x_msg_count,
2378: p_data => x_msg_data);
2379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2377: p_count => x_msg_count,
2378: p_data => x_msg_data);
2379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2380: ROLLBACK TO UPDATE_ESTIMATE;
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2383: p_count => x_msg_count,
2377: p_count => x_msg_count,
2378: p_data => x_msg_data);
2379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2380: ROLLBACK TO UPDATE_ESTIMATE;
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2383: p_count => x_msg_count,
2384: p_data => x_msg_data);
2385: WHEN OTHERS THEN
2383: p_count => x_msg_count,
2384: p_data => x_msg_data);
2385: WHEN OTHERS THEN
2386: ROLLBACK TO UPDATE_ESTIMATE;
2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2389: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2390: END IF;
2391: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2427: l_last_updated_login NUMBER;
2428: BEGIN
2429: SAVEPOINT SET_ACTIVITIES_FOR_CE;
2430:
2431: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2433: END IF;
2434:
2435: --Initialize message list if p_init_msg_list is set to TRUE.
2428: BEGIN
2429: SAVEPOINT SET_ACTIVITIES_FOR_CE;
2430:
2431: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2433: END IF;
2434:
2435: --Initialize message list if p_init_msg_list is set to TRUE.
2436: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2433: END IF;
2434:
2435: --Initialize message list if p_init_msg_list is set to TRUE.
2436: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2437: FND_MSG_PUB.INITIALIZE;
2438: END IF;
2439:
2440: --Initialize API return status to success
2437: FND_MSG_PUB.INITIALIZE;
2438: END IF;
2439:
2440: --Initialize API return status to success
2441: x_return_status := FND_API.G_RET_STS_SUCCESS;
2442:
2443: INIT_DEBUG(
2444: p_init_msg_list => p_init_msg_list,
2445: p_debug_filename => l_debug_filename,
2476: IF p_ce_id IS NULL THEN
2477: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CE_ID');
2478: FND_MESSAGE.SET_TOKEN('CE_ID', p_ce_id);
2479: FND_MSG_PUB.ADD;
2480: RAISE FND_API.G_EXC_ERROR;
2481: END IF;
2482:
2483: BEGIN
2484: SELECT ESTIMATE_ID,
2491: WHEN OTHERS THEN
2492: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CE_ID');
2493: FND_MESSAGE.SET_TOKEN('CE_ID', p_ce_id);
2494: FND_MSG_PUB.ADD;
2495: RAISE FND_API.G_EXC_ERROR;
2496: END;
2497:
2498: IF px_activities_tbl.COUNT > 0 THEN
2499: l_index := 0;
2503: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2504: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
2505: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ORGANIZATION_ID);
2506: FND_MSG_PUB.ADD;
2507: RAISE FND_API.G_EXC_ERROR;
2508: END IF;
2509:
2510: IF (px_activities_tbl(l_index).ESTIMATE_ID IS NOT NULL AND px_activities_tbl(l_index).ESTIMATE_ID <> l_ce_id) THEN
2511: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2511: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2512: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_ID');
2513: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ESTIMATE_ID);
2514: FND_MSG_PUB.ADD;
2515: RAISE FND_API.G_EXC_ERROR;
2516: END IF;
2517:
2518: l_cu_id := px_activities_tbl(l_index).CU_ID;
2519:
2521: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2522: FND_MESSAGE.SET_TOKEN('PARAMETER', 'CU_QTY');
2523: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).CU_QTY);
2524: FND_MSG_PUB.ADD;
2525: RAISE FND_API.G_EXC_ERROR;
2526: END IF;
2527: l_cu_qty := px_activities_tbl(l_index).CU_QTY;
2528:
2529: /*IF (px_activities_tbl(l_index).ACCT_CLASS_CODE IS NULL) THEN
2530: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2531: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ACCT_CLASS_CODE');
2532: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ACCT_CLASS_CODE);
2533: FND_MSG_PUB.ADD;
2534: RAISE FND_API.G_EXC_ERROR;
2535: END IF;*/
2536: l_acct_class_code := px_activities_tbl(l_index).ACCT_CLASS_CODE;
2537:
2538: IF (px_activities_tbl(l_index).ACTIVITY_ID IS NULL) THEN
2539: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2540: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ACTIVITY_ID');
2541: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ACTIVITY_ID);
2542: FND_MSG_PUB.ADD;
2543: RAISE FND_API.G_EXC_ERROR;
2544: END IF;
2545: l_activity_id := px_activities_tbl(l_index).ACTIVITY_ID;
2546:
2547: IF (px_activities_tbl(l_index).ACTIVITY_QTY IS NULL) THEN
2548: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2549: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ACTIVITY_QTY');
2550: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ACTIVITY_QTY);
2551: FND_MSG_PUB.ADD;
2552: RAISE FND_API.G_EXC_ERROR;
2553: END IF;
2554: l_activity_qty := px_activities_tbl(l_index).ACTIVITY_QTY;
2555:
2556: l_difficulty_id := px_activities_tbl(l_index).DIFFICULTY_ID;
2559: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2560: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RESOURCE_MULTIPLIER');
2561: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).RESOURCE_MULTIPLIER);
2562: FND_MSG_PUB.ADD;
2563: RAISE FND_API.G_EXC_ERROR;
2564: END IF;
2565: l_resource_multiplier := px_activities_tbl(l_index).RESOURCE_MULTIPLIER;
2566: l_est_association_id := NULL;
2567:
2589: px_activities_tbl(l_index).ESTIMATE_ASSOCIATION_ID := l_est_association_id;
2590: END LOOP;
2591: END IF;
2592:
2593: IF (p_commit = FND_API.G_TRUE) THEN
2594: COMMIT;
2595: END IF;
2596:
2597: IF (l_debug = 'Y') THEN
2598: DEBUG('x_return_status : ' || x_return_status);
2599: DEBUG('x_msg_count : ' || x_msg_count);
2600: END IF;
2601: EXCEPTION
2602: WHEN FND_API.G_EXC_ERROR THEN
2603: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2604: x_return_status := FND_API.G_RET_STS_ERROR;
2605: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2606: p_count => x_msg_count,
2600: END IF;
2601: EXCEPTION
2602: WHEN FND_API.G_EXC_ERROR THEN
2603: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2604: x_return_status := FND_API.G_RET_STS_ERROR;
2605: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2606: p_count => x_msg_count,
2607: p_data => x_msg_data);
2608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2604: x_return_status := FND_API.G_RET_STS_ERROR;
2605: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2606: p_count => x_msg_count,
2607: p_data => x_msg_data);
2608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2609: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2611: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2612: p_count => x_msg_count,
2606: p_count => x_msg_count,
2607: p_data => x_msg_data);
2608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2609: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2611: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2612: p_count => x_msg_count,
2613: p_data => x_msg_data);
2614: WHEN OTHERS THEN
2612: p_count => x_msg_count,
2613: p_data => x_msg_data);
2614: WHEN OTHERS THEN
2615: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2617: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2619: END IF;
2620: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2939: --Unsupported group option
2940: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
2941: FND_MESSAGE.SET_TOKEN('OPTION', p_group_option);
2942: FND_MSG_PUB.ADD;
2943: RAISE FND_API.G_EXC_ERROR;
2944: END IF;
2945: END GET_CE_WO_LNS_BY_GROUP_OPT;
2946:
2947: --This is a private procedure, it takes a wo defaults record and a list of wo
2999: --Unsupported group option
3000: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3001: FND_MESSAGE.SET_TOKEN('OPTION', p_group_option);
3002: FND_MSG_PUB.ADD;
3003: RAISE FND_API.G_EXC_ERROR;
3004: END IF;
3005: END IF;
3006: END LOOP;
3007: END IF;
3225: --Unsupported group option
3226: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3227: FND_MESSAGE.SET_TOKEN('OPTION', p_group_option);
3228: FND_MSG_PUB.ADD;
3229: RAISE FND_API.G_EXC_ERROR;
3230: END IF;
3231: END LOOP;
3232: END IF;
3233: END RESOLVE_SORT_CONTENTION;
3254: l_ce_wo_ln_tbl EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL;
3255: BEGIN
3256: SAVEPOINT UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3257:
3258: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3260: END IF;
3261:
3262: --Initialize message list if p_init_msg_list is set to TRUE.
3255: BEGIN
3256: SAVEPOINT UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3257:
3258: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3260: END IF;
3261:
3262: --Initialize message list if p_init_msg_list is set to TRUE.
3263: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
3259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3260: END IF;
3261:
3262: --Initialize message list if p_init_msg_list is set to TRUE.
3263: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
3264: FND_MSG_PUB.INITIALIZE;
3265: END IF;
3266:
3267: --Initialize API return status to success
3264: FND_MSG_PUB.INITIALIZE;
3265: END IF;
3266:
3267: --Initialize API return status to success
3268: x_return_status := FND_API.G_RET_STS_SUCCESS;
3269:
3270: INIT_DEBUG(
3271: p_init_msg_list => p_init_msg_list,
3272: p_debug_filename => l_debug_filename,
3312: --Unsupported group option
3313: FND_MESSAGE.SET_NAME('EAM','EAM_ERROR_DERIVE_GROUP_OPTION');
3314: FND_MESSAGE.SET_TOKEN('OPTION_ID', p_ce_wo_defaults.GROUPING_OPTION);
3315: FND_MSG_PUB.ADD;
3316: RAISE FND_API.G_EXC_ERROR;
3317: END;
3318:
3319: IF l_group_option = 'None'
3320: OR l_group_option = 'Activity'
3342: --Unsupported group option
3343: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3344: FND_MESSAGE.SET_TOKEN('OPTION', l_group_option);
3345: FND_MSG_PUB.ADD;
3346: RAISE FND_API.G_EXC_ERROR;
3347: END IF;
3348:
3349: --Now update the wo lines
3350: IF l_ce_wo_ln_tbl.COUNT > 0 THEN
3350: IF l_ce_wo_ln_tbl.COUNT > 0 THEN
3351: FOR i IN l_ce_wo_ln_tbl.FIRST..l_ce_wo_ln_tbl.LAST LOOP
3352: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
3353: p_estimate_work_order_line_id => l_ce_wo_ln_tbl(i).ESTIMATE_WORK_ORDER_LINE_ID,
3354: p_estimate_work_order_id => FND_API.G_MISS_NUM,
3355: p_src_cu_id => l_ce_wo_ln_tbl(i).SRC_CU_ID,
3356: p_src_activity_id => l_ce_wo_ln_tbl(i).SRC_ACTIVITY_ID,
3357: p_src_activity_qty => l_ce_wo_ln_tbl(i).SRC_ACTIVITY_QTY,
3358: p_src_op_seq_num => l_ce_wo_ln_tbl(i).SRC_OP_SEQ_NUM,
3408: p_di_purchase_category_id => l_ce_wo_ln_tbl(i).DI_PURCHASE_CATEGORY_ID,
3409: p_di_auto_request_material => l_ce_wo_ln_tbl(i).DI_AUTO_REQUEST_MATERIAL,
3410: p_di_need_by_date => l_ce_wo_ln_tbl(i).DI_NEED_BY_DATE,
3411: p_work_order_line_cost => l_ce_wo_ln_tbl(i).WORK_ORDER_LINE_COST,
3412: p_creation_date => FND_API.G_MISS_DATE,
3413: p_created_by => FND_API.G_MISS_NUM,
3414: p_last_update_date => SYSDATE,
3415: p_last_updated_by => FND_GLOBAL.USER_ID,
3416: p_last_update_login => FND_GLOBAL.USER_ID
3409: p_di_auto_request_material => l_ce_wo_ln_tbl(i).DI_AUTO_REQUEST_MATERIAL,
3410: p_di_need_by_date => l_ce_wo_ln_tbl(i).DI_NEED_BY_DATE,
3411: p_work_order_line_cost => l_ce_wo_ln_tbl(i).WORK_ORDER_LINE_COST,
3412: p_creation_date => FND_API.G_MISS_DATE,
3413: p_created_by => FND_API.G_MISS_NUM,
3414: p_last_update_date => SYSDATE,
3415: p_last_updated_by => FND_GLOBAL.USER_ID,
3416: p_last_update_login => FND_GLOBAL.USER_ID
3417: ,p_work_order_type => l_ce_wo_ln_tbl(i).WORK_ORDER_TYPE
3424: ,p_res_sch_flag => l_ce_wo_ln_tbl(i).RES_SCHEDULED_FLAG);
3425: END LOOP;
3426: END IF;
3427:
3428: IF p_commit = FND_API.G_TRUE THEN
3429: COMMIT;
3430: END IF;
3431: EXCEPTION
3432: WHEN FND_API.G_EXC_ERROR THEN
3428: IF p_commit = FND_API.G_TRUE THEN
3429: COMMIT;
3430: END IF;
3431: EXCEPTION
3432: WHEN FND_API.G_EXC_ERROR THEN
3433: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3434: x_return_status := FND_API.G_RET_STS_ERROR;
3435: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3436: p_count => x_msg_count,
3430: END IF;
3431: EXCEPTION
3432: WHEN FND_API.G_EXC_ERROR THEN
3433: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3434: x_return_status := FND_API.G_RET_STS_ERROR;
3435: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3436: p_count => x_msg_count,
3437: p_data => x_msg_data);
3438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3434: x_return_status := FND_API.G_RET_STS_ERROR;
3435: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3436: p_count => x_msg_count,
3437: p_data => x_msg_data);
3438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3439: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3441: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3442: p_count => x_msg_count,
3436: p_count => x_msg_count,
3437: p_data => x_msg_data);
3438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3439: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3441: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3442: p_count => x_msg_count,
3443: p_data => x_msg_data);
3444: WHEN OTHERS THEN
3442: p_count => x_msg_count,
3443: p_data => x_msg_data);
3444: WHEN OTHERS THEN
3445: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3447: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3448: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3449: END IF;
3450: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3453: END UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3454:
3455: PROCEDURE CREATE_CU_WORKORDERS(
3456: p_api_version IN NUMBER := 1.0
3457: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3458: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3459: ,p_estimate_id IN NUMBER
3460: ,x_return_status OUT NOCOPY VARCHAR2
3461: ,x_msg_count OUT NOCOPY NUMBER
3454:
3455: PROCEDURE CREATE_CU_WORKORDERS(
3456: p_api_version IN NUMBER := 1.0
3457: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3458: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3459: ,p_estimate_id IN NUMBER
3460: ,x_return_status OUT NOCOPY VARCHAR2
3461: ,x_msg_count OUT NOCOPY NUMBER
3462: ,x_msg_data OUT NOCOPY VARCHAR2
3605:
3606: -------------------------------------------------------------------------
3607: -- standard call to check for call compatibility
3608: -------------------------------------------------------------------------
3609: IF NOT fnd_api.compatible_api_call (
3610: l_api_version,
3611: p_api_version,
3612: l_api_name,
3613: G_PKG_NAME ) then
3611: p_api_version,
3612: l_api_name,
3613: G_PKG_NAME ) then
3614:
3615: RAISE fnd_api.g_exc_unexpected_error;
3616:
3617: END IF;
3618:
3619: -------------------------------------------------------------------------
3619: -------------------------------------------------------------------------
3620: -- Initialize message list if p_init_msg_list is set to TRUE
3621: -------------------------------------------------------------------------
3622: --dbms_output.put_line('2');
3623: IF FND_API.to_Boolean(p_init_msg_list) THEN
3624: FND_MSG_PUB.initialize;
3625: END IF;
3626:
3627:
3627:
3628: -------------------------------------------------------------------------
3629: -- initialize api return status to success
3630: -------------------------------------------------------------------------
3631: x_return_status := fnd_api.g_ret_sts_success;
3632:
3633: -- assign to local variables
3634: l_stmt_num := 10;
3635:
3689: , x_mesg_token_tbl => l_out_mesg_token_tbl
3690: );
3691: l_mesg_token_tbl := l_out_mesg_token_tbl;
3692:
3693: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3694: THEN
3695: --dbms_output.put_line ('Unable to open file for debug');
3696: EAM_PROCESS_WO_PVT.Set_Debug('N');
3697: END IF;
3742:
3743: IF l_wo_seq_exists = 1 THEN
3744: /* lOG errro */
3745: --dbms_output.put_line('4');
3746: RAISE FND_API.g_exc_error;
3747: END IF;
3748:
3749: EXCEPTION
3750: WHEN NO_DATA_FOUND THEN
3771:
3772: IF l_wo_exists = 1 THEN
3773: /* lOG errro */
3774: --dbms_output.put_line('4');
3775: RAISE FND_API.g_exc_error;
3776: END IF;
3777:
3778: EXCEPTION
3779: WHEN NO_DATA_FOUND THEN
3798:
3799: IF l_noasset = 1 THEN
3800: /* lOG errro */
3801: --dbms_output.put_line('4');
3802: RAISE FND_API.g_exc_error;
3803: END IF;
3804:
3805: EXCEPTION
3806: WHEN NO_DATA_FOUND THEN
3842: , x_msg_count => l_msg_count
3843: , x_msg_data => l_msg_data);
3844: --dbms_output.put_line('Back Calling PWO');
3845:
3846: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3847: --dbms_output.put_line('New WO error...');
3848: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
3849: l_api_message := 'Populate_WO returned error';
3850: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
3849: l_api_message := 'Populate_WO returned error';
3850: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
3851: FND_MESSAGE.set_token('TEXT', l_api_message);
3852: FND_MSG_pub.add;
3853: RAISE FND_API.g_exc_error;
3854: END IF;
3855:
3856: l_eam_wo_tbl(1) := l_eam_wo_rec;
3857: --dbms_output.put_line('Calling WO API for parent');
3911:
3912: IF(x_return_status <> 'S') then
3913: --dbms_output.put_line('Error after creating pwo' || SQLERRM);
3914: -- ROLLBACK TO CREATE_CU_WORKORDERS;
3915: RAISE FND_API.G_EXC_ERROR;
3916: END IF;
3917:
3918: UPDATE EAM_CE_WORK_ORDER_LINES
3919: SET estimate_work_order_id = l_eam_wo_tbl1(1).wip_entity_id
3929:
3930: EXCEPTION
3931: WHEN OTHERS THEN
3932: --dbms_output.put_line('Creating parent 2' || l_stmt_num || SQLERRM);
3933: RAISE FND_API.g_exc_error;
3934: END;
3935:
3936:
3937: END IF;
3936:
3937: END IF;
3938: EXCEPTION
3939: WHEN OTHERS THEN
3940: RAISE FND_API.g_exc_error;
3941:
3942: END;
3943:
3944: -------------------------------------------------------------------------
3980: , x_return_status => l_return_status
3981: , x_msg_count => l_msg_count
3982: , x_msg_data => l_msg_data);
3983:
3984: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3985: --dbms_output.put_line('New WO error...' || wo);
3986: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
3987: l_api_message := 'Populate_WO returned error';
3988: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
3987: l_api_message := 'Populate_WO returned error';
3988: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
3989: FND_MESSAGE.set_token('TEXT', l_api_message);
3990: FND_MSG_pub.add;
3991: RAISE FND_API.g_exc_error;
3992: END IF;
3993:
3994:
3995: l_eam_wo_tbl(wo) := l_eam_wo_rec;
4033: , x_msg_count => l_msg_count
4034: , x_msg_data => l_msg_data);
4035:
4036:
4037: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4038: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4039: l_api_message := 'POPULATE_OPERATION returned error';
4040: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4041: FND_MESSAGE.set_token('TEXT', l_api_message);
4039: l_api_message := 'POPULATE_OPERATION returned error';
4040: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4041: FND_MESSAGE.set_token('TEXT', l_api_message);
4042: FND_MSG_pub.add;
4043: RAISE FND_API.g_exc_error;
4044: END IF;
4045:
4046:
4047: l_eam_op_tbl(op) := l_eam_op_rec;
4051:
4052: l_res_seq := c_ecwl_rec.res_id;
4053: --dbms_output.put_line('Inside resource- ID...' || l_res_seq);
4054:
4055: IF (l_res_seq IS NOT null) OR (l_res_seq <> -99) OR (l_res_seq <> FND_API.G_MISS_NUM) THEN
4056: --dbms_output.put_line('Inside resource...' || l_eam_wo_tbl(1).header_id);
4057: /* This is a Resource Line */
4058: l_stmt_num := 120;
4059: res := res + 1;
4068: , x_msg_count => l_msg_count
4069: , x_msg_data => l_msg_data);
4070:
4071:
4072: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4073: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4074: l_api_message := 'POPULATE_RESOURCE returned error';
4075: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4076: FND_MESSAGE.set_token('TEXT', l_api_message);
4074: l_api_message := 'POPULATE_RESOURCE returned error';
4075: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4076: FND_MESSAGE.set_token('TEXT', l_api_message);
4077: FND_MSG_pub.add;
4078: RAISE FND_API.g_exc_error;
4079: END IF;
4080:
4081:
4082: l_eam_res_tbl(res) := l_eam_res_rec;
4085:
4086: l_mat_seq := c_ecwl_rec.mat_inventory_item_id;
4087: --dbms_output.put_line('Inside material- ID...' || l_mat_seq);
4088:
4089: IF (l_mat_seq IS NOT null) OR (l_mat_seq <> -99) OR (l_mat_seq <> FND_API.G_MISS_NUM) THEN
4090: --dbms_output.put_line('Inside mat...' || l_eam_wo_tbl(1).header_id);
4091: /* This is a Material Line */
4092: l_stmt_num := 140;
4093: mat := mat + 1;
4103: , x_msg_count => l_msg_count
4104: , x_msg_data => l_msg_data);
4105:
4106:
4107: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4108: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4109: l_api_message := 'POPULATE_MATERIAL returned error';
4110: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4111: FND_MESSAGE.set_token('TEXT', l_api_message);
4109: l_api_message := 'POPULATE_MATERIAL returned error';
4110: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4111: FND_MESSAGE.set_token('TEXT', l_api_message);
4112: FND_MSG_pub.add;
4113: RAISE FND_API.g_exc_error;
4114: END IF;
4115:
4116:
4117: l_eam_mat_req_tbl(mat) := l_eam_mat_rec;
4120:
4121: l_direct_desc := c_ecwl_rec.di_description;
4122: --dbms_output.put_line('Inside direct- ID...' || l_direct_desc);
4123:
4124: IF (l_direct_desc IS NOT null) OR (l_direct_desc <> FND_API.G_MISS_CHAR) THEN
4125: --dbms_output.put_line('Inside direct...' || l_eam_wo_tbl(1).header_id);
4126: /* This is a Material Line */
4127: l_stmt_num := 160;
4128: di := di + 1;
4138: , x_msg_count => l_msg_count
4139: , x_msg_data => l_msg_data);
4140:
4141:
4142: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4143: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4144: l_api_message := 'POPULATE_MATERIAL returned error';
4145: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4146: FND_MESSAGE.set_token('TEXT', l_api_message);
4144: l_api_message := 'POPULATE_MATERIAL returned error';
4145: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4146: FND_MESSAGE.set_token('TEXT', l_api_message);
4147: FND_MSG_pub.add;
4148: RAISE FND_API.g_exc_error;
4149: END IF;
4150:
4151:
4152: l_eam_direct_items_tbl(di) := l_eam_direct_rec;
4216: x_msg_count := l_msg_count;
4217:
4218:
4219: IF(x_return_status<>'S') then
4220: RAISE FND_API.G_EXC_ERROR;
4221: END IF;
4222:
4223:
4224: /* --dbms_output.put_line('----l_return_status---' || l_return_status);
4238: AND organization_id = l_eam_wo_tbl1(i).organization_id;
4239:
4240: EXCEPTION
4241: WHEN OTHERS THEN
4242: RAISE FND_API.G_EXC_ERROR;
4243: END;
4244: END LOOP;
4245:
4246: COMMIT;
4246: COMMIT;
4247:
4248: EXCEPTION
4249:
4250: WHEN fnd_api.g_exc_error THEN
4251: --ROLLBACK TO
4252: ROLLBACK TO CREATE_CU_WORKORDERS;
4253: x_return_status := fnd_api.g_ret_sts_error;
4254: --dbms_output.put_line('exzc');
4249:
4250: WHEN fnd_api.g_exc_error THEN
4251: --ROLLBACK TO
4252: ROLLBACK TO CREATE_CU_WORKORDERS;
4253: x_return_status := fnd_api.g_ret_sts_error;
4254: --dbms_output.put_line('exzc');
4255:
4256: -- Get message count and data
4257: fnd_msg_pub.count_and_get
4258: ( p_count => x_msg_count
4259: , p_data => x_msg_data
4260: );
4261: --
4262: WHEN fnd_api.g_exc_unexpected_error THEN
4263: ROLLBACK TO CREATE_CU_WORKORDERS;
4264: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4265: --dbms_output.put_line('unex');
4266:
4260: );
4261: --
4262: WHEN fnd_api.g_exc_unexpected_error THEN
4263: ROLLBACK TO CREATE_CU_WORKORDERS;
4264: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4265: --dbms_output.put_line('unex');
4266:
4267: -- Get message count and data
4268: fnd_msg_pub.count_and_get
4270: , p_data => x_msg_data
4271: );
4272: --
4273: WHEN OTHERS THEN
4274: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4275: --dbms_output.put_line('others' || l_stmt_num);
4276: --
4277: ROLLBACK TO CREATE_CU_WORKORDERS;
4278: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4291: END CREATE_CU_WORKORDERS;
4292:
4293: procedure populate_WO(
4294: p_parent_wo IN NUMBER
4295: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4296: , p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4297: , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
4298: , x_return_status OUT NOCOPY VARCHAR2
4299: , x_msg_count OUT NOCOPY NUMBER
4309: BEGIN
4310:
4311: l_string := 'Inside' || G_PKG_NAME || '.Populate_WO';
4312:
4313: x_return_status := fnd_api.g_ret_sts_success;
4314:
4315: IF fnd_api.to_Boolean(p_init_msg_list) then
4316: fnd_msg_pub.initialize;
4317: end if;
4311: l_string := 'Inside' || G_PKG_NAME || '.Populate_WO';
4312:
4313: x_return_status := fnd_api.g_ret_sts_success;
4314:
4315: IF fnd_api.to_Boolean(p_init_msg_list) then
4316: fnd_msg_pub.initialize;
4317: end if;
4318:
4319: /* Is this the parent WO record */
4383:
4384: EXCEPTION
4385: WHEN OTHERS THEN
4386: DEBUG('Cannot find the item id');
4387: RAISE FND_API.g_exc_error;
4388: END;
4389:
4390: --Populate the failure entry record -- bug 7675526 Begin
4391:
4420: -- Print messages to log file
4421:
4422:
4423: EXCEPTION
4424: WHEN fnd_api.g_exc_error THEN
4425: x_return_status := fnd_api.g_ret_sts_error;
4426:
4427: -- Get message count and data
4428: fnd_msg_pub.count_and_get
4421:
4422:
4423: EXCEPTION
4424: WHEN fnd_api.g_exc_error THEN
4425: x_return_status := fnd_api.g_ret_sts_error;
4426:
4427: -- Get message count and data
4428: fnd_msg_pub.count_and_get
4429: ( p_count => x_msg_count
4429: ( p_count => x_msg_count
4430: , p_data => x_msg_data
4431: );
4432:
4433: WHEN fnd_api.g_exc_unexpected_error THEN
4434: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4435:
4436: -- Get message count and data
4437: fnd_msg_pub.count_and_get
4430: , p_data => x_msg_data
4431: );
4432:
4433: WHEN fnd_api.g_exc_unexpected_error THEN
4434: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4435:
4436: -- Get message count and data
4437: fnd_msg_pub.count_and_get
4438: ( p_count => x_msg_count
4439: , p_data => x_msg_data
4440: );
4441: --
4442: WHEN OTHERS THEN
4443: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4444: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4445: THEN
4446: fnd_msg_pub.add_exc_msg
4447: ( 'EAM_CONSTRUCTION_EST_PVT'
4460: END populate_WO;
4461:
4462: procedure POPULATE_OPERATION(
4463: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4464: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4465: , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type
4466: , x_return_status OUT NOCOPY VARCHAR2
4467: , x_msg_count OUT NOCOPY NUMBER
4468: , x_msg_data OUT NOCOPY VARCHAR2
4471: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
4472: l_stmt_num NUMBER := 0;
4473: BEGIN
4474:
4475: IF fnd_api.to_Boolean(p_init_msg_list) then
4476: fnd_msg_pub.initialize;
4477: end if;
4478:
4479: x_return_status := fnd_api.g_ret_sts_success;
4475: IF fnd_api.to_Boolean(p_init_msg_list) then
4476: fnd_msg_pub.initialize;
4477: end if;
4478:
4479: x_return_status := fnd_api.g_ret_sts_success;
4480:
4481: l_eam_op_rec := x_eam_op_rec;
4482:
4483: l_eam_op_rec.organization_id := p_ce_line_rec.organization_id;
4504: -- Print messages to log file
4505:
4506:
4507: EXCEPTION
4508: WHEN fnd_api.g_exc_error THEN
4509: x_return_status := fnd_api.g_ret_sts_error;
4510:
4511: -- Get message count and data
4512: fnd_msg_pub.count_and_get
4505:
4506:
4507: EXCEPTION
4508: WHEN fnd_api.g_exc_error THEN
4509: x_return_status := fnd_api.g_ret_sts_error;
4510:
4511: -- Get message count and data
4512: fnd_msg_pub.count_and_get
4513: ( p_count => x_msg_count
4513: ( p_count => x_msg_count
4514: , p_data => x_msg_data
4515: );
4516:
4517: WHEN fnd_api.g_exc_unexpected_error THEN
4518: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4519:
4520: -- Get message count and data
4521: fnd_msg_pub.count_and_get
4514: , p_data => x_msg_data
4515: );
4516:
4517: WHEN fnd_api.g_exc_unexpected_error THEN
4518: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4519:
4520: -- Get message count and data
4521: fnd_msg_pub.count_and_get
4522: ( p_count => x_msg_count
4523: , p_data => x_msg_data
4524: );
4525: --
4526: WHEN OTHERS THEN
4527: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4528: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_OPERATION: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4529: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4530: THEN
4531: fnd_msg_pub.add_exc_msg
4544: END POPULATE_OPERATION;
4545:
4546: procedure POPULATE_RESOURCE(
4547: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4548: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4549: , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_rec_type
4550: , x_return_status OUT NOCOPY VARCHAR2
4551: , x_msg_count OUT NOCOPY NUMBER
4552: , x_msg_data OUT NOCOPY VARCHAR2
4556: l_stmt_num NUMBER := 0;
4557: l_autocharge NUMBER;
4558: BEGIN
4559:
4560: IF fnd_api.to_Boolean(p_init_msg_list) then
4561: fnd_msg_pub.initialize;
4562: end if;
4563:
4564: x_return_status := fnd_api.g_ret_sts_success;
4560: IF fnd_api.to_Boolean(p_init_msg_list) then
4561: fnd_msg_pub.initialize;
4562: end if;
4563:
4564: x_return_status := fnd_api.g_ret_sts_success;
4565:
4566: l_eam_res_rec := x_eam_res_rec;
4567:
4568: l_eam_res_rec.organization_id := p_ce_line_rec.organization_id;
4613: -- Print messages to log file
4614:
4615:
4616: EXCEPTION
4617: WHEN fnd_api.g_exc_error THEN
4618: x_return_status := fnd_api.g_ret_sts_error;
4619:
4620: -- Get message count and data
4621: fnd_msg_pub.count_and_get
4614:
4615:
4616: EXCEPTION
4617: WHEN fnd_api.g_exc_error THEN
4618: x_return_status := fnd_api.g_ret_sts_error;
4619:
4620: -- Get message count and data
4621: fnd_msg_pub.count_and_get
4622: ( p_count => x_msg_count
4622: ( p_count => x_msg_count
4623: , p_data => x_msg_data
4624: );
4625:
4626: WHEN fnd_api.g_exc_unexpected_error THEN
4627: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4628:
4629: -- Get message count and data
4630: fnd_msg_pub.count_and_get
4623: , p_data => x_msg_data
4624: );
4625:
4626: WHEN fnd_api.g_exc_unexpected_error THEN
4627: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4628:
4629: -- Get message count and data
4630: fnd_msg_pub.count_and_get
4631: ( p_count => x_msg_count
4632: , p_data => x_msg_data
4633: );
4634: --
4635: WHEN OTHERS THEN
4636: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4637: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4638: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4639: THEN
4640: fnd_msg_pub.add_exc_msg
4653: END POPULATE_RESOURCE;
4654:
4655: procedure POPULATE_MATERIAL(
4656: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
4657: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4658: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
4659: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
4660: , x_return_status OUT NOCOPY VARCHAR2
4661: , x_msg_count OUT NOCOPY NUMBER
4666: l_eam_direct_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
4667: l_stmt_num NUMBER := 0;
4668: BEGIN
4669:
4670: IF fnd_api.to_Boolean(p_init_msg_list) then
4671: fnd_msg_pub.initialize;
4672: end if;
4673:
4674: x_return_status := fnd_api.g_ret_sts_success;
4670: IF fnd_api.to_Boolean(p_init_msg_list) then
4671: fnd_msg_pub.initialize;
4672: end if;
4673:
4674: x_return_status := fnd_api.g_ret_sts_success;
4675:
4676: l_eam_mat_rec := x_eam_mat_rec;
4677: l_eam_direct_rec := x_eam_direct_rec;
4678:
4724: -- Print messages to log file
4725:
4726:
4727: EXCEPTION
4728: WHEN fnd_api.g_exc_error THEN
4729: x_return_status := fnd_api.g_ret_sts_error;
4730:
4731: -- Get message count and data
4732: fnd_msg_pub.count_and_get
4725:
4726:
4727: EXCEPTION
4728: WHEN fnd_api.g_exc_error THEN
4729: x_return_status := fnd_api.g_ret_sts_error;
4730:
4731: -- Get message count and data
4732: fnd_msg_pub.count_and_get
4733: ( p_count => x_msg_count
4733: ( p_count => x_msg_count
4734: , p_data => x_msg_data
4735: );
4736:
4737: WHEN fnd_api.g_exc_unexpected_error THEN
4738: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4739:
4740: -- Get message count and data
4741: fnd_msg_pub.count_and_get
4734: , p_data => x_msg_data
4735: );
4736:
4737: WHEN fnd_api.g_exc_unexpected_error THEN
4738: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4739:
4740: -- Get message count and data
4741: fnd_msg_pub.count_and_get
4742: ( p_count => x_msg_count
4743: , p_data => x_msg_data
4744: );
4745: --
4746: WHEN OTHERS THEN
4747: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4748: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4749: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4750: THEN
4751: fnd_msg_pub.add_exc_msg
4813: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
4814: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
4815: FND_MESSAGE.SET_TOKEN('VALUE', p_org_id);
4816: FND_MSG_PUB.ADD;
4817: RAISE FND_API.G_EXC_ERROR;
4818: END IF;
4819:
4820: IF (p_src_estimate_id IS NULL) THEN
4821: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
4821: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
4822: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_ID');
4823: FND_MESSAGE.SET_TOKEN('VALUE', p_src_estimate_id);
4824: FND_MSG_PUB.ADD;
4825: RAISE FND_API.G_EXC_ERROR;
4826: END IF;
4827:
4828: -- Fetch the Estimates Cursor
4829: OPEN SRC_ESTIMATES_CUR;
4840: l_estimate_rec.ESTIMATE_DESCRIPTION := 'Copy of ' || l_estimate_rec.ESTIMATE_DESCRIPTION;
4841: END IF; -- l_estimate_rec.ESTIMATE_DESCRIPTION IS NULL
4842:
4843: IF NVL(l_estimate_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
4844: NVL(l_estimate_rec.PARENT_WO_ID,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4845: -- In this case the PARENT_WO_ID corresponds to the
4846: -- ESTIMATE_WORK_ORDER_LINE_ID in the ce work order lines table
4847: -- This parent information needs to be copied and updated
4848:
4851: l_estimate_rec.PARENT_WO_ID := NULL;
4852: l_estimate_rec.CREATE_PARENT_WO_FLAG := 'Y';
4853:
4854: ELSIF NVL(l_estimate_rec.CREATE_PARENT_WO_FLAG,'N') = 'N' AND
4855: NVL(l_estimate_rec.PARENT_WO_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4856:
4857: l_estimate_rec.PARENT_WO_ID := NULL;
4858: l_estimate_rec.CREATE_PARENT_WO_FLAG := 'N';
4859:
4857: l_estimate_rec.PARENT_WO_ID := NULL;
4858: l_estimate_rec.CREATE_PARENT_WO_FLAG := 'N';
4859:
4860: ELSIF NVL(l_estimate_rec.CREATE_PARENT_WO_FLAG,'N') = 'N' AND
4861: NVL(l_estimate_rec.PARENT_WO_ID,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4862:
4863: -- l_estimate_rec.PARENT_WO_ID := NULL;
4864: l_estimate_rec.CREATE_PARENT_WO_FLAG := 'N';
4865:
4901: p_ATTRIBUTE14 => l_estimate_rec.attribute14,
4902: p_ATTRIBUTE15 => l_estimate_rec.attribute15
4903: );
4904:
4905: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
4906: -- Log error, but continue processing
4907: x_return_status := FND_API.G_RET_STS_ERROR;
4908: RAISE FND_API.G_EXC_ERROR;
4909: END IF; -- nvl(l_return_status,'S') <> 'S'
4903: );
4904:
4905: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
4906: -- Log error, but continue processing
4907: x_return_status := FND_API.G_RET_STS_ERROR;
4908: RAISE FND_API.G_EXC_ERROR;
4909: END IF; -- nvl(l_return_status,'S') <> 'S'
4910:
4911: -- Newly Copied Estimate ID
4904:
4905: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
4906: -- Log error, but continue processing
4907: x_return_status := FND_API.G_RET_STS_ERROR;
4908: RAISE FND_API.G_EXC_ERROR;
4909: END IF; -- nvl(l_return_status,'S') <> 'S'
4910:
4911: -- Newly Copied Estimate ID
4912: p_cpy_estimate_id := l_estimate_rec.ESTIMATE_ID;
5111:
5112: IF NVL(p_commit,'F') = 'T' THEN
5113: COMMIT;
5114: END IF;
5115: x_return_status := FND_API.G_RET_STS_SUCCESS;
5116:
5117: EXCEPTION
5118: WHEN FND_API.G_EXC_ERROR THEN
5119: ROLLBACK TO COPY_EST_WORKBENCH;
5114: END IF;
5115: x_return_status := FND_API.G_RET_STS_SUCCESS;
5116:
5117: EXCEPTION
5118: WHEN FND_API.G_EXC_ERROR THEN
5119: ROLLBACK TO COPY_EST_WORKBENCH;
5120: x_return_status := FND_API.G_RET_STS_ERROR;
5121: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5122: p_data => x_msg_data);
5116:
5117: EXCEPTION
5118: WHEN FND_API.G_EXC_ERROR THEN
5119: ROLLBACK TO COPY_EST_WORKBENCH;
5120: x_return_status := FND_API.G_RET_STS_ERROR;
5121: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5122: p_data => x_msg_data);
5123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5124: ROLLBACK TO COPY_EST_WORKBENCH;
5119: ROLLBACK TO COPY_EST_WORKBENCH;
5120: x_return_status := FND_API.G_RET_STS_ERROR;
5121: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5122: p_data => x_msg_data);
5123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5124: ROLLBACK TO COPY_EST_WORKBENCH;
5125:
5126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5127: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5122: p_data => x_msg_data);
5123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5124: ROLLBACK TO COPY_EST_WORKBENCH;
5125:
5126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5127: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5128: p_data => x_msg_data);
5129: WHEN OTHERS THEN
5130: ROLLBACK TO COPY_EST_WORKBENCH;
5127: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5128: p_data => x_msg_data);
5129: WHEN OTHERS THEN
5130: ROLLBACK TO COPY_EST_WORKBENCH;
5131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5132: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5133: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'COPY_EST_WORKBENCH');
5134: END IF;
5135: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,