[Home] [Help]
17:
18: IF p_bom_copy_option NOT IN (1, 2) THEN
19: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACTCOPY_BOM_COPY_OPT');
20: -- FND_MESSAGE.SET_ENCODED('BOM Copy Option should be 1 (NONE) or 2 (ALL).');
21: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
22: RAISE FND_API.G_EXC_ERROR;
23: END IF;
24:
25: IF p_routing_copy_option NOT IN (1, 2) THEN
24:
25: IF p_routing_copy_option NOT IN (1, 2) THEN
26: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACTCOPY_RTG_COPY_OPT');
27: -- FND_MESSAGE.SET_ENCODED('Routing Copy Option should be 1 (NONE) or 2 (ALL).');
28: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
29: RAISE FND_API.G_EXC_ERROR;
30: END IF;
31:
32: IF p_bom_copy_option NOT IN (1, 2) THEN
31:
32: IF p_bom_copy_option NOT IN (1, 2) THEN
33: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACTCOPY_ASC_COPY_OPT');
34: -- FND_MESSAGE.SET_ENCODED('Association Copy Option should be 1 (NONE) or 2 (ALL).');
35: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:
39: END;
55: IF p_material_copy_option <> 1 THEN
56: -- Error: Material Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).
57: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_MAT_COPY_OPT_NOT_NONE');
58: -- FND_MESSAGE.SET_ENCODED('Material Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).');
59: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62: IF p_resource_copy_option <> 1 THEN
63: -- Error: Resource Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).
62: IF p_resource_copy_option <> 1 THEN
63: -- Error: Resource Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).
64: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RES_COPY_OPT_NOT_NONE');
65: -- FND_MESSAGE.SET_ENCODED('Resource Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).');
66: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
67: RAISE FND_API.G_EXC_ERROR;
68: END IF;
69: ELSIF p_operation_copy_option = 2 THEN
70: -- p_operation_copy_option = 2 (ALL)
74: -- Error: Material Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).
75: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_MAT_COPY_OPT_INVALID');
76: -- FND_MESSAGE.SET_ENCODED('Material Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).');
77: RAISE FND_API.G_EXC_ERROR;
78: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
79: END IF;
80: IF p_resource_copy_option NOT IN (1, 2, 3) THEN
81: -- Error: Resource Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).
82: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RES_COPY_OPT_INVALID');
80: IF p_resource_copy_option NOT IN (1, 2, 3) THEN
81: -- Error: Resource Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).
82: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RES_COPY_OPT_INVALID');
83: -- FND_MESSAGE.SET_ENCODED('Resource Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).');
84: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87: ELSE
88: -- Error: Operation Copy Option should be either 1 (NONE), or 2 (ALL).
87: ELSE
88: -- Error: Operation Copy Option should be either 1 (NONE), or 2 (ALL).
89: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_OP_COPY_OPT_INVALID');
90: -- FND_MESSAGE.SET_ENCODED('Operation Copy Option should be either 1 (NONE), or 2 (ALL).');
91: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
92: RAISE FND_API.G_EXC_ERROR;
93: END IF;
94:
95: -- Validation of p_association_copy_option is independent of the others.
100: -- 2003-01-10: Enchancement: if source Work Order has no Activity, treat Copy Option All as Current
101: -- So don't have to check for source Work Order Activity any more.
102:
103: /*
104: l_activity_id_from_wo := EAM_ActivityUtilities_PVT.Get_Act_Id_From_Work_Order(p_work_order_rec.wip_entity_id);
105: IF l_activity_id_from_wo IS NULL THEN
106: -- No Activity linked to source Work Order
107: IF p_association_copy_option NOT IN (1, 2) THEN
108: -- Error: When Source Work Order is not linked to an Activity, Association Copy Option should be either 1 (NONE), or 2 (CURRENT).
107: IF p_association_copy_option NOT IN (1, 2) THEN
108: -- Error: When Source Work Order is not linked to an Activity, Association Copy Option should be either 1 (NONE), or 2 (CURRENT).
109: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ASSO_COPY_OPT_NO_ACT');
110: -- FND_MESSAGE.SET_ENCODED('When Source Work Order is not linked to an Activity, Association Copy Option should be either 1 (NONE), or 2 (CURRENT).');
111: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114: ELSE
115: -- l_activity_id_from_wo IS NOT NULL
117: IF p_association_copy_option NOT IN (1, 2, 3) THEN
118: -- Error: Association Copy Option should be either 1 (NONE), 2 (CURRENT), or 3 (ALL).
119: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ASSO_COPY_OPT_INVALID');
120: -- FND_MESSAGE.SET_ENCODED('Association Copy Option should be either 1 (NONE), 2 (CURRENT), or 3 (ALL).');
121: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124: /*
125: END IF;
204: WHERE organization_id = p_organization_id
205: AND wip_entity_id = p_wip_entity_id;
206:
207: BEGIN
208: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
209: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
205: AND wip_entity_id = p_wip_entity_id;
206:
207: BEGIN
208: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
209: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
206:
207: BEGIN
208: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
209: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
207: BEGIN
208: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
209: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
208: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
209: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
209: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
217: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
217: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
218: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
217: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
218: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
219:
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
217: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
218: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
219:
220:
213: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
217: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
218: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
219:
220:
221: -- Create Operations
214: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
217: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
218: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
219:
220:
221: -- Create Operations
222: -- We need 1 Routing Header, table of Operations and Operation Networks, and table of Resources
255: l_operation_tbl(l_operation_tbl_index).Operation_Sequence_Number := l_wip_operation_row.Operation_Seq_Num;
256: l_operation_tbl(l_operation_tbl_index).standard_operation_code := l_code; -- 13519051
257: l_operation_tbl(l_operation_tbl_index).Start_Effective_Date := l_effectivity_date;
258: l_operation_tbl(l_operation_tbl_index).Department_Code :=
259: EAM_ActivityUtilities_PVT.Get_Department_Code(l_wip_operation_row.Organization_Id,
260: l_wip_operation_row.department_id);
261: l_operation_tbl(l_operation_tbl_index).Operation_Description := l_wip_operation_row.Description;
262: l_operation_tbl(l_operation_tbl_index).Count_Point_Type := l_wip_operation_row.count_point_type;
263: l_operation_tbl(l_operation_tbl_index).Backflush_Flag := l_wip_operation_row.Backflush_Flag;
302: l_op_network_tbl(l_op_network_tbl_index).From_Start_Effective_Date := l_effectivity_date;
303: l_op_network_tbl(l_op_network_tbl_index).To_Op_Seq_Number := l_wip_op_network_row.Next_Operation;
304: l_op_network_tbl(l_op_network_tbl_index).To_Start_Effective_Date := l_effectivity_date;
305:
306: EAM_ActivityUtilities_PVT.Get_Op_Coordinates(
307: p_organization_id => p_work_order_rec.organization_id,
308: p_wip_entity_id => p_work_order_rec.wip_entity_id,
309: p_operation_seq_num => l_wip_op_network_row.Prior_Operation,
310: x_x_pos => l_x_pos,
312: );
313: l_op_network_tbl(l_op_network_tbl_index).From_X_Coordinate := l_x_pos;
314: l_op_network_tbl(l_op_network_tbl_index).From_Y_Coordinate := l_y_pos;
315:
316: EAM_ActivityUtilities_PVT.Get_Op_Coordinates(
317: p_organization_id => p_work_order_rec.organization_id,
318: p_wip_entity_id => p_work_order_rec.wip_entity_id,
319: p_operation_seq_num => l_wip_op_network_row.Next_Operation,
320: x_x_pos => l_x_pos,
373: l_op_resource_tbl(l_op_resource_tbl_index).Organization_Code := l_rtg_header_rec.Organization_Code;
374: l_op_resource_tbl(l_op_resource_tbl_index).Assembly_Item_Name := l_rtg_header_rec.Assembly_Item_Name;
375: l_op_resource_tbl(l_op_resource_tbl_index).Operation_Sequence_Number := l_wip_resource_row.Operation_Seq_Num;
376: l_op_resource_tbl(l_op_resource_tbl_index).Resource_Code :=
377: EAM_ActivityUtilities_PVT.Get_Resource_Code(l_wip_resource_row.Organization_Id,
378: l_wip_resource_row.Resource_Id);
379: l_op_resource_tbl(l_op_resource_tbl_index).Op_Start_Effective_Date := l_effectivity_date;
380: l_op_resource_tbl(l_op_resource_tbl_index).Resource_Sequence_Number := l_wip_resource_row.Resource_Seq_Num;
381:
385: l_wip_resource_row.Applied_Resource_Units;
386: ELSE
387: -- p_resource_copy_option = 3 (ALL)
388: l_op_resource_tbl(l_op_resource_tbl_index).Usage_Rate_Or_Amount :=
389: EAM_ActivityUtilities_PVT.Get_WO_Res_Scheduled_Units(
390: l_wip_resource_row.Organization_Id,
391: l_wip_resource_row.Wip_Entity_Id,
392: l_wip_resource_row.Operation_Seq_Num,
393: l_wip_resource_row.Resource_Seq_Num);
393: l_wip_resource_row.Resource_Seq_Num);
394: END IF;
395:
396: l_op_resource_tbl(l_op_resource_tbl_index).Activity :=
397: EAM_ActivityUtilities_PVT.Get_Cost_Activity(l_wip_resource_row.Activity_Id);
398: l_op_resource_tbl(l_op_resource_tbl_index).Schedule_Flag := l_wip_resource_row.Scheduled_Flag;
399: l_op_resource_tbl(l_op_resource_tbl_index).Assigned_Units := l_wip_resource_row.Assigned_Units;
400: l_op_resource_tbl(l_op_resource_tbl_index).Autocharge_Type := l_wip_resource_row.Autocharge_Type;
401: l_op_resource_tbl(l_op_resource_tbl_index).Standard_Rate_Flag := l_wip_resource_row.Standard_Rate_Flag;
430: -- Only Call Routing Business Object API if operation tabel is not empty
431: IF l_operation_tbl.FIRST IS NOT NULL THEN
432: Error_Handler.initialize;
433: -- log call to Process_Rtg API
434: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_RTG_PUB.Process_Rtg INPUT Parameters >>>>>>>>>>>>>>>');
435: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_rtg_header_rec,
436: l_operation_tbl,
437: l_op_resource_tbl,
438: l_op_network_tbl);
431: IF l_operation_tbl.FIRST IS NOT NULL THEN
432: Error_Handler.initialize;
433: -- log call to Process_Rtg API
434: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_RTG_PUB.Process_Rtg INPUT Parameters >>>>>>>>>>>>>>>');
435: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_rtg_header_rec,
436: l_operation_tbl,
437: l_op_resource_tbl,
438: l_op_network_tbl);
439:
436: l_operation_tbl,
437: l_op_resource_tbl,
438: l_op_network_tbl);
439:
440: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
441: BOM_RTG_PUB.Process_Rtg(
442: p_rtg_header_rec => l_rtg_header_rec
443: , p_operation_tbl => l_operation_tbl
444: , p_op_resource_tbl => l_op_resource_tbl
451: , x_op_network_tbl => l_x_op_network_tbl
452: , x_return_status => l_x_rtg_return_status
453: , x_msg_count => l_x_rtg_msg_count
454: );
455: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
456:
457: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
458:
459: -- log errors
456:
457: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
458:
459: -- log errors
460: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
461: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
457: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
458:
459: -- log errors
460: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
461: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
459: -- log errors
460: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
461: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
467: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
460: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
461: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
467: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
468: l_x_operation_tbl,
461: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
467: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
468: l_x_operation_tbl,
469: l_x_op_resource_tbl,
462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
467: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
468: l_x_operation_tbl,
469: l_x_op_resource_tbl,
470: l_x_op_network_tbl);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
467: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
468: l_x_operation_tbl,
469: l_x_op_resource_tbl,
470: l_x_op_network_tbl);
471:
481: x_rtg_msg_list := l_x_rtg_msg_list;
482:
483: END IF;
484:
485: EAM_ActivityUtilities_PVT.Write_Debug('---------- Exiting EAM_Activity_PUB.Create_Activity_Routing ----------');
486: END;
487:
488: -- ----------------------------------------------------------------------
489: PROCEDURE Create_Activity_BOM(
554: l_bom_component_tbl(l_bom_comp_tbl_index).Start_Effective_Date := l_effectivity_date;
555: l_bom_component_tbl(l_bom_comp_tbl_index).Operation_Sequence_Number :=
556: l_wip_requirement_row.Operation_Seq_Num;
557: l_bom_component_tbl(l_bom_comp_tbl_index).Component_Item_Name :=
558: EAM_ActivityUtilities_PVT.Get_Item_Concatenated_Segments(l_wip_requirement_row.organization_id,
559: l_wip_requirement_row.inventory_item_id);
560: -- l_bom_component_tbl(l_bom_comp_tbl_index).Item_Sequence_Number :=
561: -- l_wip_requirement_row.Component_Sequence_Id;
562: -- l_bom_component_tbl(l_bom_comp_tbl_index).Item_Sequence_Number := l_bom_comp_tbl_index;
573:
574: l_bom_component_tbl(l_bom_comp_tbl_index).Wip_Supply_Type := l_wip_requirement_row.Wip_Supply_Type;
575: l_bom_component_tbl(l_bom_comp_tbl_index).Supply_Subinventory := l_wip_requirement_row.Supply_Subinventory;
576: l_bom_component_tbl(l_bom_comp_tbl_index).Location_Name :=
577: EAM_ActivityUtilities_PVT.Get_Locator(l_wip_requirement_row.organization_id,
578: l_wip_requirement_row.Supply_Subinventory,
579: l_wip_requirement_row.Supply_Locator_Id);
580: l_bom_component_tbl(l_bom_comp_tbl_index).Attribute_Category := l_wip_requirement_row.Attribute_Category;
581: l_bom_component_tbl(l_bom_comp_tbl_index).Attribute1 := l_wip_requirement_row.Attribute1;
622: IF l_bom_component_tbl.FIRST IS NOT NULL THEN
623:
624: Error_Handler.initialize;
625: -- log call to Process_BOM API
626: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
627: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
628: l_bom_component_tbl);
629:
630: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
623:
624: Error_Handler.initialize;
625: -- log call to Process_BOM API
626: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
627: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
628: l_bom_component_tbl);
629:
630: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
631: BOM_BO_PUB.Process_BOM(
626: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
627: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
628: l_bom_component_tbl);
629:
630: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
631: BOM_BO_PUB.Process_BOM(
632: p_bom_header_rec => l_bom_head_rec,
633: p_bom_component_tbl => l_bom_component_tbl,
634: x_bom_header_rec => l_x_bom_header_rec,
638: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
639: x_return_status => l_x_bom_return_status,
640: x_msg_count => l_x_bom_msg_count
641: );
642: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
643:
644: Error_Handler.Get_Message_List(l_x_bom_msg_list);
645:
646: -- log errors
643:
644: Error_Handler.Get_Message_List(l_x_bom_msg_list);
645:
646: -- log errors
647: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
648: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
644: Error_Handler.Get_Message_List(l_x_bom_msg_list);
645:
646: -- log errors
647: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
648: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
646: -- log errors
647: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
648: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
653: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
654: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
647: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
648: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
653: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
654: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
655: l_x_bom_component_tbl);
648: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
653: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
654: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
655: l_x_bom_component_tbl);
656:
649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
653: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
654: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
655: l_x_bom_component_tbl);
656:
657:
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
653: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
654: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
655: l_x_bom_component_tbl);
656:
657:
658: -- Assign outputs.
729: -- Copy input activity record to a working record
730: l_item_rec := p_asset_activity;
731:
732: -- Validate org id and org code
733: EAM_ActivityUtilities_PVT.Validate_Organization(
734: p_organization_id => l_item_rec.organization_id,
735: p_organization_code => l_item_rec.organization_code,
736: x_return_status => l_validate_org_ret_sts,
737: x_organization_id => l_temp_org_id,
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:
747: -- ============================================================
748: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Create_Item --------');
749:
750: -- Save current org id
751: l_curr_organization_id := l_item_rec.organization_id;
752: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);
748: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Create_Item --------');
749:
750: -- Save current org id
751: l_curr_organization_id := l_item_rec.organization_id;
752: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);
753:
754: -- 2 a) Get master org id
755: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(l_curr_organization_id);
756: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
751: l_curr_organization_id := l_item_rec.organization_id;
752: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);
753:
754: -- 2 a) Get master org id
755: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(l_curr_organization_id);
756: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
757:
758: -- Set attributes of l_item_rec
759: l_item_rec.eam_item_type := 2; -- EAM Asset Activity
752: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);
753:
754: -- 2 a) Get master org id
755: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(l_curr_organization_id);
756: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
757:
758: -- Set attributes of l_item_rec
759: l_item_rec.eam_item_type := 2; -- EAM Asset Activity
760:
765:
766: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
767: THEN
768: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
769: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
770: END IF;
771:
772: /* Bug 13418048 Avoiding expense account required check as activity is not costed or purchased
773: -- Check that expense_account is not null
775: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
776: THEN
777: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
778: -- FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
779: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
780: RAISE FND_API.G_EXC_ERROR;
781: END IF; */
782:
783: IF l_item_rec.bom_enabled_flag IS NULL OR
791: -- set org to master org
792: l_item_rec.organization_id := l_master_organization_id;
793: l_item_rec.organization_code := NULL;
794:
795: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
796: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
797: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
798: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
799: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
792: l_item_rec.organization_id := l_master_organization_id;
793: l_item_rec.organization_code := NULL;
794:
795: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
796: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
797: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
798: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
799: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
800: INV_Item_GRP.Create_Item(
793: l_item_rec.organization_code := NULL;
794:
795: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
796: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
797: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
798: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
799: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
800: INV_Item_GRP.Create_Item(
801: p_Item_rec => l_item_rec,
794:
795: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
796: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
797: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
798: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
799: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
800: INV_Item_GRP.Create_Item(
801: p_Item_rec => l_item_rec,
802: p_Template_Id => p_template_id,
795: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
796: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
797: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
798: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
799: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
800: INV_Item_GRP.Create_Item(
801: p_Item_rec => l_item_rec,
802: p_Template_Id => p_template_id,
803: p_Template_Name => p_template_name,
810: x_master_item_return_status := l_x_master_item_return_status;
811: x_master_item_error_tbl := l_x_master_item_error_tbl;
812:
813: -- log outputs
814: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
816: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
811: x_master_item_error_tbl := l_x_master_item_error_tbl;
812:
813: -- log outputs
814: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
816: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
819: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
812:
813: -- log outputs
814: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
816: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
819: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
820:
813: -- log outputs
814: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
816: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
819: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
820:
821: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
814: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
816: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
819: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
820:
821: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: -- Create Item under master org fail, no use tyring to create it under child org.
815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
816: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
819: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
820:
821: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: -- Create Item under master org fail, no use tyring to create it under child org.
823: RETURN;
823: RETURN;
824: END IF;
825: ELSE
826: -- Current Org is Master Org, no additional Item needs to be created.
827: EAM_ActivityUtilities_PVT.Write_Debug('Current Org is Master Org, no additional Item needs to be created.');
828: x_master_item_rec := l_x_master_item_rec; -- should be NULL
829: x_master_item_return_status := FND_API.G_RET_STS_SUCCESS;
830: x_master_item_error_tbl := l_x_master_item_error_tbl; -- should be NULL
831: END IF;
836: l_item_rec.organization_code := NULL;
837: /*Bug3269789 - Added below code since master items form uses exp acct of child org
838: when assigning to child org*/
839: /*Bug#3269789 - start*/
840: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_curr_organization_id);
841:
842: /* Bug 13838073 Avoiding expense account required check as activity is not costed or purchased
843:
844: -- Check that expense_account is not null
845: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
846: THEN
847: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
848: -- FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
849: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;*/
852: /*Bug#3269789 - end*/
853:
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;*/
852: /*Bug#3269789 - end*/
853:
854: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
855: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
856: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
857: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
858: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
851: END IF;*/
852: /*Bug#3269789 - end*/
853:
854: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
855: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
856: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
857: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
858: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
859: INV_Item_GRP.Create_Item(
852: /*Bug#3269789 - end*/
853:
854: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
855: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
856: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
857: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
858: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
859: INV_Item_GRP.Create_Item(
860: p_Item_rec => l_item_rec,
853:
854: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
855: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
856: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
857: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
858: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
859: INV_Item_GRP.Create_Item(
860: p_Item_rec => l_item_rec,
861: p_Template_Id => p_template_id,
854: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
855: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
856: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
857: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
858: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
859: INV_Item_GRP.Create_Item(
860: p_Item_rec => l_item_rec,
861: p_Template_Id => p_template_id,
862: p_Template_Name => p_template_name,
869: x_curr_item_return_status := l_x_curr_item_return_status;
870: x_curr_item_error_tbl := l_x_curr_item_error_tbl;
871:
872: -- log outputs
873: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
875: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
870: x_curr_item_error_tbl := l_x_curr_item_error_tbl;
871:
872: -- log outputs
873: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
875: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
871:
872: -- log outputs
873: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
875: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
879:
872: -- log outputs
873: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
875: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
879:
880: -- ============================================================
873: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
875: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
879:
880: -- ============================================================
881: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');
874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
875: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
879:
880: -- ============================================================
881: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');
882: END;
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
879:
880: -- ============================================================
881: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');
882: END;
883:
884: -- ======================================================================
885: PROCEDURE Create_Activity
1008: x_return_status := FND_API.G_RET_STS_SUCCESS;
1009: -- API body
1010:
1011: -- ============================================================
1012: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
1013: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1014: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1015: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1009: -- API body
1010:
1011: -- ============================================================
1012: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
1013: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1014: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1015: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1017: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1010:
1011: -- ============================================================
1012: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
1013: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1014: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1015: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1017: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1018: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1011: -- ============================================================
1012: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
1013: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1014: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1015: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1017: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1018: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1019: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1012: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
1013: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1014: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1015: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1017: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1018: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1019: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1020: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1013: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1014: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1015: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1017: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1018: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1019: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1020: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1021: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1014: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1015: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1017: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1018: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1019: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1020: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1021: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1022: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1015: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1017: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1018: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1019: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1020: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1021: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1022: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1023: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1017: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1018: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1019: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1020: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1021: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1022: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1023: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1024: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1017: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1018: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1019: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1020: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1021: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1022: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1023: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1024: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1025: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1018: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1019: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1020: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1021: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1022: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1023: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1024: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1025: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1026: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1019: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1020: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1021: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1022: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1023: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1024: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1025: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1026: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1027: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1020: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1021: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1022: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1023: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1024: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1025: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1026: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1027: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1028: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1021: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1022: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1023: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1024: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1025: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1026: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1027: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1028: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1029: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1022: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1023: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1024: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1025: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1026: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1027: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1028: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1029: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1030: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1023: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1024: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1025: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1026: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1027: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1028: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1029: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1030: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1031: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1024: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1025: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1026: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1027: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1028: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1029: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1030: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1031: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1032: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1025: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1026: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1027: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1028: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1029: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1030: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1031: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1032: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1033: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1026: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1027: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1028: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1029: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1030: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1031: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1032: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1033: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1034: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1027: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1028: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1029: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1030: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1031: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1032: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1033: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1034: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1035: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1028: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1029: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1030: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1031: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1032: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1033: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1034: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1035: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1036: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1029: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1030: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1031: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1032: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1033: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1034: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1035: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1036: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1037: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1030: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1031: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1032: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1033: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1034: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1035: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1036: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1037: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1038:
1031: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1032: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1033: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1034: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1035: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1036: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1037: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1038:
1039: -- ============================================================
1032: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1033: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1034: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1035: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1036: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1037: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1038:
1039: -- ============================================================
1040: -- Step 1: Validate inputs
1033: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1034: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1035: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1036: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1037: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1038:
1039: -- ============================================================
1040: -- Step 1: Validate inputs
1041: -- 1 a) Validate source Work Order
1038:
1039: -- ============================================================
1040: -- Step 1: Validate inputs
1041: -- 1 a) Validate source Work Order
1042: EAM_ActivityUtilities_PVT.Validate_Work_Order(
1043: p_work_order_rec => p_work_order_rec,
1044: x_return_status => l_x_work_order_ret_sts,
1045: x_work_order_rec => l_x_work_order_rec
1046: );
1088:
1089: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1090: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
1091: -- FND_MESSAGE.SET_ENCODED('Create Activity under Master Organization failed.');
1092: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095:
1096: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1095:
1096: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1097: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
1098: -- FND_MESSAGE.SET_ENCODED('Create Activity under Current Organization failed.');
1099: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1100: RAISE FND_API.G_EXC_ERROR;
1101: END IF;
1102:
1103: -- Set the Activity Attributes in the Item Record, don't have to do it manually
1190: -- Handle errors
1191: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1192: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');
1193: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1194: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1195: RAISE FND_API.G_EXC_ERROR;
1196: END IF;
1197:
1198:
1224: -- Handle errors
1225: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1226: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1227: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1228: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1229: RAISE FND_API.G_EXC_ERROR;
1230: END IF;
1231:
1232:
1259: -- Handle error
1260: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1261: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ASSOC_FAILED');
1262: -- FND_MESSAGE.SET_ENCODED('Create Activity Associations failed.');
1263: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1264: RAISE FND_API.G_EXC_ERROR;
1265: END IF;
1266:
1267: END IF;
1279: p_data => x_msg_data
1280: );
1281:
1282:
1283: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity ==========');
1284:
1285: -- ======================================================================
1286:
1287: EXCEPTION
1286:
1287: EXCEPTION
1288: WHEN FND_API.G_EXC_ERROR THEN
1289: ROLLBACK TO Create_Activity_PUB;
1290: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: EXPECTED_ERROR ==========');
1291: x_return_status := FND_API.G_RET_STS_ERROR ;
1292: FND_MSG_PUB.Count_And_Get
1293: ( p_count => x_msg_count ,
1294: p_data => x_msg_data
1294: p_data => x_msg_data
1295: );
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: ROLLBACK TO Create_Activity_PUB;
1298: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: UNEXPECTED_ERROR ==========');
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1300: FND_MSG_PUB.Count_And_Get
1301: ( p_count => x_msg_count ,
1302: p_data => x_msg_data
1311: ( G_PKG_NAME ,
1312: l_api_name
1313: );
1314: -- log error message also
1315: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1316: END IF;
1317: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1318: FND_MSG_PUB.Count_And_Get
1319: ( p_count => x_msg_count ,
1313: );
1314: -- log error message also
1315: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1316: END IF;
1317: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1318: FND_MSG_PUB.Count_And_Get
1319: ( p_count => x_msg_count ,
1320: p_data => x_msg_data
1321: );
1450: x_return_status := FND_API.G_RET_STS_SUCCESS;
1451: -- API body
1452:
1453: -- ============================================================
1454: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1455: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1456: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1457: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1451: -- API body
1452:
1453: -- ============================================================
1454: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1455: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1456: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1457: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1459: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1452:
1453: -- ============================================================
1454: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1455: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1456: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1457: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1459: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1460: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1453: -- ============================================================
1454: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1455: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1456: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1457: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1459: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1460: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1461: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1454: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1455: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1456: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1457: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1459: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1460: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1461: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1462: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1455: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1456: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1457: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1459: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1460: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1461: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1462: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1463: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1456: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1457: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1459: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1460: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1461: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1462: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1463: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1464: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1457: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1459: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1460: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1461: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1462: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1463: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1464: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1465: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1459: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1460: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1461: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1462: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1463: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1464: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1465: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1466: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1459: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1460: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1461: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1462: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1463: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1464: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1465: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1466: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1467: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1460: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1461: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1462: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1463: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1464: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1465: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1466: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1467: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1468: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1461: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1462: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1463: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1464: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1465: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1466: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1467: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1468: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1469: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1462: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1463: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1464: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1465: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1466: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1467: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1468: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1469: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1470: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1463: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1464: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1465: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1466: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1467: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1468: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1469: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1470: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1471: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1464: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1465: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1466: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1467: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1468: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1469: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1470: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1471: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1472: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1465: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1466: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1467: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1468: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1469: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1470: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1471: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1472: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1473: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1466: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1467: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1468: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1469: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1470: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1471: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1472: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1473: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1474: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1467: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1468: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1469: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1470: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1471: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1472: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1473: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1474: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1475: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1468: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1469: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1470: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1471: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1472: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1473: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1474: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1475: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1476: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1469: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1470: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1471: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1472: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1473: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1474: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1475: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1476: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1477: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1470: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1471: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1472: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1473: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1474: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1475: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1476: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1477: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1478: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1471: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1472: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1473: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1474: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1475: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1476: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1477: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1478: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1479: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1472: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1473: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1474: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1475: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1476: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1477: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1478: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1479: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1480:
1473: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1474: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1475: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1476: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1477: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1478: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1479: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1480:
1481: -- ============================================================
1474: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1475: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1476: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1477: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1478: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1479: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1480:
1481: -- ============================================================
1482: -- Step 1: Validate inputs
1475: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1476: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1477: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1478: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1479: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1480:
1481: -- ============================================================
1482: -- Step 1: Validate inputs
1483: -- 1 a) Validate ???
1517:
1518: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1519: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
1520: -- FND_MESSAGE.SET_ENCODED('Create Activity under Master Organization failed.');
1521: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:
1525: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1524:
1525: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1526: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
1527: -- FND_MESSAGE.SET_ENCODED('Create Activity under Current Organization failed.');
1528: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1529: RAISE FND_API.G_EXC_ERROR;
1530: END IF;
1531:
1532: -- Set the Activity Attributes in the Item Record, don't have to do it manually
1591: -- Bug # 3662214 : Need to create Routing first and then BOM so
1592: -- that operation sequence number in BOM is retained.
1593:
1594: -- Step 3: Copy Routing
1595: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Routing --------');
1596:
1597: -- 3 a) Check Routing Copy Option
1598: EAM_ActivityUtilities_PVT.Write_Debug('p_routing_copy_option=' || p_routing_copy_option);
1599: IF p_routing_copy_option = 2 THEN
1594: -- Step 3: Copy Routing
1595: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Routing --------');
1596:
1597: -- 3 a) Check Routing Copy Option
1598: EAM_ActivityUtilities_PVT.Write_Debug('p_routing_copy_option=' || p_routing_copy_option);
1599: IF p_routing_copy_option = 2 THEN
1600:
1601: -- 3 b) Check if Source has Routing (sequence id)
1602: l_source_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1598: EAM_ActivityUtilities_PVT.Write_Debug('p_routing_copy_option=' || p_routing_copy_option);
1599: IF p_routing_copy_option = 2 THEN
1600:
1601: -- 3 b) Check if Source has Routing (sequence id)
1602: l_source_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1603: p_organization_id => p_source_org_id,
1604: p_assembly_item_id => p_source_activity_id,
1605: p_alternate_rtg_designator => p_source_alt_rtg_designator);
1606: EAM_ActivityUtilities_PVT.Write_Debug('l_source_rtg_sequence_id=' || l_source_rtg_sequence_id);
1602: l_source_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1603: p_organization_id => p_source_org_id,
1604: p_assembly_item_id => p_source_activity_id,
1605: p_alternate_rtg_designator => p_source_alt_rtg_designator);
1606: EAM_ActivityUtilities_PVT.Write_Debug('l_source_rtg_sequence_id=' || l_source_rtg_sequence_id);
1607:
1608: IF l_source_rtg_sequence_id IS NULL THEN
1609: -- Source Activity does not have Routing, nothing to copy
1610: NULL;
1619: l_rtg_header_rec.Organization_Code := l_x_curr_item_rec.Organization_Code;
1620:
1621: Error_Handler.initialize;
1622: -- log call to Process_Rtg API
1623: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
1624: BOM_RTG_PUB.Process_Rtg(
1625: p_rtg_header_rec => l_rtg_header_rec
1626: , x_rtg_header_rec => l_x_rtg_header_rec
1627: , x_rtg_revision_tbl => l_x_rtg_revision_tbl
1631: , x_op_network_tbl => l_x_op_network_tbl
1632: , x_return_status => l_x_rtg_return_status
1633: , x_msg_count => l_x_rtg_msg_count
1634: );
1635: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
1636:
1637: -- log errors
1638: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1634: );
1635: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
1636:
1637: -- log errors
1638: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1640: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1641: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1642: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1635: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
1636:
1637: -- log errors
1638: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1640: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1641: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1642: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1643: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1637: -- log errors
1638: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1640: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1641: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1642: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1643: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1644:
1645: -- Handle errors
1638: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1640: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1641: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1642: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1643: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1644:
1645: -- Handle errors
1646: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1640: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1641: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1642: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1643: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1644:
1645: -- Handle errors
1646: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1647: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1645: -- Handle errors
1646: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1647: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1648: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1649: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:
1653: l_target_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1649: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:
1653: l_target_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1654: p_organization_id => l_x_curr_item_rec.organization_id,
1655: p_assembly_item_id => l_x_curr_item_rec.inventory_item_id,
1656: p_alternate_rtg_designator => NULL);
1657: EAM_ActivityUtilities_PVT.Write_Debug('l_target_rtg_sequence_id=' || l_target_rtg_sequence_id);
1653: l_target_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1654: p_organization_id => l_x_curr_item_rec.organization_id,
1655: p_assembly_item_id => l_x_curr_item_rec.inventory_item_id,
1656: p_alternate_rtg_designator => NULL);
1657: EAM_ActivityUtilities_PVT.Write_Debug('l_target_rtg_sequence_id=' || l_target_rtg_sequence_id);
1658:
1659: -- 4 d) Call copy_routing API
1660: -- log call to copy_routing API
1661: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_COPY_ROUTING.copy_routing **********');
1657: EAM_ActivityUtilities_PVT.Write_Debug('l_target_rtg_sequence_id=' || l_target_rtg_sequence_id);
1658:
1659: -- 4 d) Call copy_routing API
1660: -- log call to copy_routing API
1661: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_COPY_ROUTING.copy_routing **********');
1662: BOM_COPY_ROUTING.copy_routing(
1663: to_sequence_id => l_target_rtg_sequence_id,
1664: from_sequence_id => l_source_rtg_sequence_id,
1665: from_org_id => p_source_org_id,
1669: direction => 1,
1670: to_alternate => NULL,
1671: rev_date => p_source_rtg_rev_date
1672: );
1673: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_ROUTING.copy_routing **********');
1674:
1675: -- write copy_routing error message to fnd message stack and log file
1676: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1677: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1672: );
1673: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_ROUTING.copy_routing **********');
1674:
1675: -- write copy_routing error message to fnd message stack and log file
1676: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1677: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1678: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_ROUTING.copy_routing <<<<<');
1679:
1680: END IF; -- l_source_rtg_sequence_id IS NULL
1673: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_ROUTING.copy_routing **********');
1674:
1675: -- write copy_routing error message to fnd message stack and log file
1676: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1677: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1678: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_ROUTING.copy_routing <<<<<');
1679:
1680: END IF; -- l_source_rtg_sequence_id IS NULL
1681:
1674:
1675: -- write copy_routing error message to fnd message stack and log file
1676: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1677: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1678: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_ROUTING.copy_routing <<<<<');
1679:
1680: END IF; -- l_source_rtg_sequence_id IS NULL
1681:
1682: END IF; -- p_routing_copy_option
1680: END IF; -- l_source_rtg_sequence_id IS NULL
1681:
1682: END IF; -- p_routing_copy_option
1683:
1684: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy Routing --------');
1685:
1686: -- ============================================================
1687: -- Step 4: Copy BOM
1688: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy BOM --------');
1684: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy Routing --------');
1685:
1686: -- ============================================================
1687: -- Step 4: Copy BOM
1688: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy BOM --------');
1689:
1690: -- 4 a) Check BOM Copy Option
1691: EAM_ActivityUtilities_PVT.Write_Debug('p_bom_copy_option=' || p_bom_copy_option);
1692: IF p_bom_copy_option = 2 THEN
1687: -- Step 4: Copy BOM
1688: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy BOM --------');
1689:
1690: -- 4 a) Check BOM Copy Option
1691: EAM_ActivityUtilities_PVT.Write_Debug('p_bom_copy_option=' || p_bom_copy_option);
1692: IF p_bom_copy_option = 2 THEN
1693:
1694: -- 4 b) Check if Source has BOM (sequence_id)
1695: l_source_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1691: EAM_ActivityUtilities_PVT.Write_Debug('p_bom_copy_option=' || p_bom_copy_option);
1692: IF p_bom_copy_option = 2 THEN
1693:
1694: -- 4 b) Check if Source has BOM (sequence_id)
1695: l_source_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1696: p_organization_id => p_source_org_id,
1697: p_assembly_item_id => p_source_activity_id,
1698: p_alternate_bom_designator => p_source_alt_bom_designator);
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_source_bom_sequence_id=' || l_source_bom_sequence_id);
1695: l_source_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1696: p_organization_id => p_source_org_id,
1697: p_assembly_item_id => p_source_activity_id,
1698: p_alternate_bom_designator => p_source_alt_bom_designator);
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_source_bom_sequence_id=' || l_source_bom_sequence_id);
1700:
1701: IF l_source_bom_sequence_id IS NULL THEN
1702: -- Source Activity does not have BOM, nothing to copy
1703: NULL;
1712:
1713: -- Create empty BOM header through BOM Business Object API
1714: Error_Handler.initialize;
1715: -- log call to Process_BOM API
1716: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
1717: BOM_BO_PUB.Process_BOM(
1718: p_bom_header_rec => l_bom_head_rec,
1719: x_bom_header_rec => l_x_bom_header_rec,
1720: x_bom_revision_tbl => l_x_bom_revision_tbl,
1723: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
1724: x_return_status => l_x_bom_return_status,
1725: x_msg_count => l_x_bom_msg_count
1726: );
1727: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
1728:
1729: -- log errors
1730: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1726: );
1727: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
1728:
1729: -- log errors
1730: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1732: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1733: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1734: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1727: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
1728:
1729: -- log errors
1730: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1732: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1733: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1734: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1735: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1729: -- log errors
1730: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1732: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1733: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1734: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1735: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1736:
1737: -- Handle errors
1730: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1732: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1733: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1734: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1735: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1736:
1737: -- Handle errors
1738: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1732: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1733: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1734: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1735: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1736:
1737: -- Handle errors
1738: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1739: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');
1737: -- Handle errors
1738: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1739: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');
1740: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1741: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;
1744:
1745: l_target_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1741: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;
1744:
1745: l_target_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1746: p_organization_id => l_x_curr_item_rec.organization_id,
1747: p_assembly_item_id => l_x_curr_item_rec.inventory_item_id,
1748: p_alternate_bom_designator => NULL);
1749: EAM_ActivityUtilities_PVT.Write_Debug('l_target_bom_sequence_id=' || l_target_bom_sequence_id);
1745: l_target_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1746: p_organization_id => l_x_curr_item_rec.organization_id,
1747: p_assembly_item_id => l_x_curr_item_rec.inventory_item_id,
1748: p_alternate_bom_designator => NULL);
1749: EAM_ActivityUtilities_PVT.Write_Debug('l_target_bom_sequence_id=' || l_target_bom_sequence_id);
1750:
1751: -- 3 d) Call copy_bill API
1752: -- log call to copy_bill API
1753: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_COPY_BILL.copy_bill **********');
1749: EAM_ActivityUtilities_PVT.Write_Debug('l_target_bom_sequence_id=' || l_target_bom_sequence_id);
1750:
1751: -- 3 d) Call copy_bill API
1752: -- log call to copy_bill API
1753: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_COPY_BILL.copy_bill **********');
1754: BOM_COPY_BILL.copy_bill(
1755: to_sequence_id => l_target_bom_sequence_id,
1756: from_sequence_id => l_source_bom_sequence_id,
1757: from_org_id => p_source_org_id,
1766: bill_or_eco => 1,
1767: eco_eff_date => NULL,
1768: from_item_id => p_source_activity_id
1769: );
1770: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_BILL.copy_bill **********');
1771:
1772: -- write copy_bill error message to fnd message stack and log file
1773: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1774: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1769: );
1770: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_BILL.copy_bill **********');
1771:
1772: -- write copy_bill error message to fnd message stack and log file
1773: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1774: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1775: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_BILL.copy_bill <<<<<');
1776:
1777:
1770: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_BILL.copy_bill **********');
1771:
1772: -- write copy_bill error message to fnd message stack and log file
1773: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1774: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1775: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_BILL.copy_bill <<<<<');
1776:
1777:
1778: END IF; -- l_source_bom_sequence_id IS NULL
1771:
1772: -- write copy_bill error message to fnd message stack and log file
1773: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1774: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1775: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_BILL.copy_bill <<<<<');
1776:
1777:
1778: END IF; -- l_source_bom_sequence_id IS NULL
1779:
1778: END IF; -- l_source_bom_sequence_id IS NULL
1779:
1780: END IF; -- p_bom_copy_option = 2
1781:
1782: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy BOM --------');
1783:
1784: -- ============================================================
1785: -- Step 5: Update Association to Asset Numbers for the newly created activity
1786: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Association --------');
1782: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy BOM --------');
1783:
1784: -- ============================================================
1785: -- Step 5: Update Association to Asset Numbers for the newly created activity
1786: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Association --------');
1787:
1788: EAM_ActivityUtilities_PVT.Write_Debug('p_association_copy_option=' || p_association_copy_option);
1789: IF p_association_copy_option <> 1 THEN
1790: -- p_association_copy_option <> 1 (NONE), call private package to create association
1784: -- ============================================================
1785: -- Step 5: Update Association to Asset Numbers for the newly created activity
1786: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Association --------');
1787:
1788: EAM_ActivityUtilities_PVT.Write_Debug('p_association_copy_option=' || p_association_copy_option);
1789: IF p_association_copy_option <> 1 THEN
1790: -- p_association_copy_option <> 1 (NONE), call private package to create association
1791: EAM_ActivityUtilities_PVT.Write_Debug(
1792: '********** Calling EAM_ActivityAssociation_PVT.Create_Association **********');
1787:
1788: EAM_ActivityUtilities_PVT.Write_Debug('p_association_copy_option=' || p_association_copy_option);
1789: IF p_association_copy_option <> 1 THEN
1790: -- p_association_copy_option <> 1 (NONE), call private package to create association
1791: EAM_ActivityUtilities_PVT.Write_Debug(
1792: '********** Calling EAM_ActivityAssociation_PVT.Create_Association **********');
1793: EAM_ActivityAssociation_PVT.Create_Association(
1794: p_api_version => 1.0,
1795: x_return_status => l_x_assoc_return_status,
1805:
1806: x_act_num_association_tbl => l_x_act_num_association_tbl,
1807: x_activity_association_tbl => l_x_activity_association_tbl
1808: );
1809: EAM_ActivityUtilities_PVT.Write_Debug(
1810: '********** Returned from EAM_ActivityAssociation_PVT.Create_Association **********');
1811: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_return_status=' || l_x_assoc_return_status);
1812: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_count=' || l_x_assoc_msg_count);
1813: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_data=' || l_x_assoc_msg_data);
1807: x_activity_association_tbl => l_x_activity_association_tbl
1808: );
1809: EAM_ActivityUtilities_PVT.Write_Debug(
1810: '********** Returned from EAM_ActivityAssociation_PVT.Create_Association **********');
1811: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_return_status=' || l_x_assoc_return_status);
1812: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_count=' || l_x_assoc_msg_count);
1813: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_data=' || l_x_assoc_msg_data);
1814:
1815: -- Assing outputs
1808: );
1809: EAM_ActivityUtilities_PVT.Write_Debug(
1810: '********** Returned from EAM_ActivityAssociation_PVT.Create_Association **********');
1811: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_return_status=' || l_x_assoc_return_status);
1812: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_count=' || l_x_assoc_msg_count);
1813: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_data=' || l_x_assoc_msg_data);
1814:
1815: -- Assing outputs
1816: x_assoc_return_status := l_x_assoc_return_status;
1809: EAM_ActivityUtilities_PVT.Write_Debug(
1810: '********** Returned from EAM_ActivityAssociation_PVT.Create_Association **********');
1811: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_return_status=' || l_x_assoc_return_status);
1812: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_count=' || l_x_assoc_msg_count);
1813: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_data=' || l_x_assoc_msg_data);
1814:
1815: -- Assing outputs
1816: x_assoc_return_status := l_x_assoc_return_status;
1817: x_assoc_msg_count := l_x_assoc_msg_count;
1822: -- Handle error
1823: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1824: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ASSOC_FAILED');
1825: -- FND_MESSAGE.SET_ENCODED('Create Activity Associations failed.');
1826: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1827: RAISE FND_API.G_EXC_ERROR;
1828: END IF;
1829:
1830: END IF;
1828: END IF;
1829:
1830: END IF;
1831:
1832: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy Association --------');
1833:
1834: -- ======================================================================
1835:
1836:
1844: ( p_count => x_msg_count ,
1845: p_data => x_msg_data
1846: );
1847:
1848: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Copy_Activity ==========');
1849:
1850:
1851: -- ======================================================================
1852: EXCEPTION
1851: -- ======================================================================
1852: EXCEPTION
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO Copy_Activity_PUB;
1855: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: EXPECTED_ERROR ==========');
1856: x_return_status := FND_API.G_RET_STS_ERROR ;
1857: FND_MSG_PUB.Count_And_Get
1858: ( p_count => x_msg_count ,
1859: p_data => x_msg_data
1859: p_data => x_msg_data
1860: );
1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1862: ROLLBACK TO Copy_Activity_PUB;
1863: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: UNEXPECTED_ERROR ==========');
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1865: FND_MSG_PUB.Count_And_Get
1866: ( p_count => x_msg_count ,
1867: p_data => x_msg_data
1877: ( G_PKG_NAME ,
1878: l_api_name
1879: );
1880: -- log error message also
1881: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1882: END IF;
1883: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1884: FND_MSG_PUB.Count_And_Get
1885: ( p_count => x_msg_count ,
1879: );
1880: -- log error message also
1881: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1882: END IF;
1883: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1884: FND_MSG_PUB.Count_And_Get
1885: ( p_count => x_msg_count ,
1886: p_data => x_msg_data
1887: );
1978: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1979:
1980: BEGIN
1981:
1982: EAM_ActivityUtilities_PVT.Open_Debug_Session;
1983:
1984: -- 1: Step up activity parameters
1985: l_work_order_rec.wip_entity_id := p_wip_entity_id;
1986: l_asset_activity.Description := p_description;
2103: ELSE
2104: x_successful := FALSE;
2105: END IF;
2106:
2107: EAM_ActivityUtilities_PVT.Close_Debug_Session;
2108:
2109: END Create_Activity_From_Form;
2110:
2111:
2195: x_return_status := FND_API.G_RET_STS_SUCCESS;
2196: -- API body
2197:
2198: -- ============================================================
2199: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2200: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2201: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2202: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2196: -- API body
2197:
2198: -- ============================================================
2199: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2200: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2201: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2202: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2204: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2197:
2198: -- ============================================================
2199: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2200: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2201: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2202: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2204: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2205: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2198: -- ============================================================
2199: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2200: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2201: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2202: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2204: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2205: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2206: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2199: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2200: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2201: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2202: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2204: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2205: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2206: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2207: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2200: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2201: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2202: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2204: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2205: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2206: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2207: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2208: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2201: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2202: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2204: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2205: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2206: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2207: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2208: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2209: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2202: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2204: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2205: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2206: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2207: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2208: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2209: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2210: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2204: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2205: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2206: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2207: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2208: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2209: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2210: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2211: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2204: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2205: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2206: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2207: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2208: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2209: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2210: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2211: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2212: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2205: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2206: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2207: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2208: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2209: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2210: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2211: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2212: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2213: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2206: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2207: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2208: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2209: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2210: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2211: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2212: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2213: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2214: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2207: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2208: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2209: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2210: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2211: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2212: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2213: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2214: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2215: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2208: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2209: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2210: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2211: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2212: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2213: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2214: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2215: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2216: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2209: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2210: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2211: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2212: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2213: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2214: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2215: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2216: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2217: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2210: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2211: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2212: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2213: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2214: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2215: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2216: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2217: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2218: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2211: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2212: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2213: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2214: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2215: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2216: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2217: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2218: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2219: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2212: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2213: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2214: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2215: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2216: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2217: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2218: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2219: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2220: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2213: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2214: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2215: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2216: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2217: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2218: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2219: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2220: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2221: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2214: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2215: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2216: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2217: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2218: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2219: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2220: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2221: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2222: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2215: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2216: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2217: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2218: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2219: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2220: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2221: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2222: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2223: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2216: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2217: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2218: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2219: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2220: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2221: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2222: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2223: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2224:
2217: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2218: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2219: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2220: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2221: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2222: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2223: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2224:
2225: -- ============================================================
2218: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2219: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2220: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2221: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2222: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2223: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2224:
2225: -- ============================================================
2226: -- Create Asset Activity. Call INV_Item_GRP package.
2219: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2220: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2221: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2222: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2223: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2224:
2225: -- ============================================================
2226: -- Create Asset Activity. Call INV_Item_GRP package.
2227:
2306: x_master_item_error_tbl := l_x_master_item_error_tbl;
2307:
2308: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2309: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
2310: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
2311: RAISE FND_API.G_EXC_ERROR;
2312: END IF;
2313:
2314: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2312: END IF;
2313:
2314: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2315: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
2316: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
2317: RAISE FND_API.G_EXC_ERROR;
2318: END IF;
2319:
2320: -- =============================================================
2330: p_data => x_msg_data
2331: );
2332:
2333:
2334: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity_With_Template ==========');
2335:
2336: -- ======================================================================
2337:
2338: EXCEPTION
2337:
2338: EXCEPTION
2339: WHEN FND_API.G_EXC_ERROR THEN
2340: ROLLBACK TO Create_Act_With_Templ_PUB;
2341: EAM_ActivityUtilities_PVT.Write_Debug(
2342: '========== EAM_Activity_PUB.Create_Activity_With_Template: EXPECTED ERROR ==========');
2343: x_return_status := FND_API.G_RET_STS_ERROR ;
2344: FND_MSG_PUB.Count_And_Get
2345: ( p_count => x_msg_count ,
2346: p_data => x_msg_data
2347: );
2348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2349: ROLLBACK TO Create_Act_With_Templ_PUB;
2350: EAM_ActivityUtilities_PVT.Write_Debug(
2351: '========== EAM_Activity_PUB.Create_Activity_With_Template: UNEXPECTED ERROR ==========');
2352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2353: FND_MSG_PUB.Count_And_Get
2354: ( p_count => x_msg_count ,
2355: p_data => x_msg_data
2356: );
2357: WHEN OTHERS THEN
2358: ROLLBACK TO Create_Act_With_Templ_PUB;
2359: EAM_ActivityUtilities_PVT.Write_Debug(
2360: '========== EAM_Activity_PUB.Create_Activity_With_Template: OTHER ERROR ==========');
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362: IF FND_MSG_PUB.Check_Msg_Level
2363: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2440: */
2441: --l_bom_head_rec.Alternate_Bom_Code := l_bom_bom_row.alternate_bom_designator;
2442: --l_bom_head_rec.Assembly_Type := l_bom_bom_row.assembly_type;
2443: -- log call to Process_BOM API
2444: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
2445: BOM_BO_PUB.Process_BOM(
2446: p_bom_header_rec => l_bom_head_rec,
2447: p_bom_component_tbl => l_bom_component_tbl,
2448: x_bom_header_rec => l_x_bom_header_rec,
2452: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
2453: x_return_status => l_x_bom_return_status,
2454: x_msg_count => l_x_bom_msg_count
2455: );
2456: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
2457:
2458: x_bom_header_rec := l_x_bom_header_rec;
2459: x_bom_revision_tbl := l_x_bom_revision_tbl;
2460: x_bom_component_tbl := l_x_bom_component_tbl;
2576: begin
2577:
2578:
2579: -- ============================================================
2580: EAM_ActivityUtilities_PVT.Open_Debug_Session;
2581:
2582: create_activity_with_template(
2583: p_api_version => l_api_version,
2584: p_init_msg_list => l_init_msg_list,
2637: x_success := FALSE;
2638: end if;*/
2639:
2640: -- ============================================================
2641: EAM_ActivityUtilities_PVT.Close_Debug_Session;
2642:
2643: end create_activity_with_template;
2644:
2645: PROCEDURE Create_Routing_Header(
2689: l_rtg_header_rec.Transaction_Type := l_create_txn_type;
2690:
2691: Error_Handler.initialize;
2692: -- log call to Process_Rtg API
2693: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
2694: BOM_RTG_PUB.Process_Rtg(
2695: p_rtg_header_rec => l_rtg_header_rec
2696: , p_operation_tbl => l_operation_tbl
2697: , p_op_resource_tbl => l_op_resource_tbl
2704: , x_op_network_tbl => l_x_op_network_tbl
2705: , x_return_status => l_x_rtg_return_status
2706: , x_msg_count => l_x_rtg_msg_count
2707: );
2708: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
2709:
2710: -- Assign outputs.
2711: x_rtg_header_rec := l_x_rtg_header_rec;
2712: x_rtg_revision_tbl := l_x_rtg_revision_tbl;
2841: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2842: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2843: begin
2844:
2845: EAM_ActivityUtilities_PVT.Open_Debug_Session;
2846:
2847: -- Set up Item Number. Use segments if specified.
2848: IF p_segment1 IS NOT NULL OR
2849: p_segment2 IS NOT NULL OR
2941: x_act_num_association_tbl => l_x_act_num_association_tbl ,
2942: x_activity_association_tbl => l_x_activity_association_tbl
2943: );
2944:
2945: EAM_ActivityUtilities_PVT.Close_Debug_Session;
2946:
2947: end Copy_Activity;
2948:
2949:
2980:
2981: BEGIN
2982: SAVEPOINT EAM_Activity_PUB;
2983: -- Standard call to check for call compatibility.
2984: --EAM_ActivityUtilities_PVT.Open_Debug_Session;
2985: IF NOT fnd_api.compatible_api_call(
2986: l_api_version
2987: ,p_api_version
2988: ,l_api_name
2995: fnd_msg_pub.initialize;
2996: END IF;
2997: */
2998: -- Get master org id
2999: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(p_org_id);
3000: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
3001:
3002: BEGIN
3003: -- check if the activity exists in Master organization
2996: END IF;
2997: */
2998: -- Get master org id
2999: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(p_org_id);
3000: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
3001:
3002: BEGIN
3003: -- check if the activity exists in Master organization
3004: SELECT segment1, segment2, segment3, segment4, segment5, segment6, segment7,
3019: WHERE organization_id = l_master_organization_id
3020: AND inventory_item_id = p_activity_id;
3021:
3022: -- Validate org id and org code
3023: EAM_ActivityUtilities_PVT.Validate_Organization(
3024: p_organization_id => p_org_id,
3025: p_organization_code => l_item_rec.organization_code,
3026: x_return_status => l_x_return_status,
3027: x_organization_id => l_item_rec.organization_id,
3033: RAISE FND_API.G_EXC_ERROR;
3034: END IF;
3035:
3036: -- ============================================================
3037: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Activity_org_assign --------');
3038:
3039:
3040: IF l_item_rec.inventory_item_flag IS NULL OR
3041: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN
3043: END IF;
3044: /*
3045: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3046: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
3047: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
3048: END IF;
3049: -- Check that expense_account is not null
3050: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3051: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
3049: -- Check that expense_account is not null
3050: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3051: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
3052: --FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
3053: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3054:
3055: RAISE FND_API.G_EXC_ERROR;
3056:
3057: END IF;
3061: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR THEN
3062: l_item_rec.bom_enabled_flag := 'Y';
3063: END IF;
3064:
3065: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3066: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3067:
3068:
3069: INV_Item_GRP.Create_Item
3062: l_item_rec.bom_enabled_flag := 'Y';
3063: END IF;
3064:
3065: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3066: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3067:
3068:
3069: INV_Item_GRP.Create_Item
3070: (
3082: x_error_msg_new=>l_error_string
3083: );
3084:
3085: -- log outputs
3086: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3088: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3083: );
3084:
3085: -- log outputs
3086: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3088: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3091: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3084:
3085: -- log outputs
3086: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3088: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3091: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3092:
3085: -- log outputs
3086: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3088: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3091: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3092:
3093: EXCEPTION
3086: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3088: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3091: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3092:
3093: EXCEPTION
3094: WHEN NO_DATA_FOUND THEN
3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3088: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3091: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3092:
3093: EXCEPTION
3094: WHEN NO_DATA_FOUND THEN
3095: -- There is no record in master org... so create in both ...
3111: WHERE inventory_item_id = p_activity_id
3112: AND ROWNUM = 1;
3113:
3114: l_item_rec.organization_id := p_org_id;
3115: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
3116: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3117: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3118:
3119: Create_Item(
3112: AND ROWNUM = 1;
3113:
3114: l_item_rec.organization_id := p_org_id;
3115: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
3116: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3117: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3118:
3119: Create_Item(
3120: p_asset_activity => l_item_rec,
3113:
3114: l_item_rec.organization_id := p_org_id;
3115: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
3116: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3117: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3118:
3119: Create_Item(
3120: p_asset_activity => l_item_rec,
3121: p_template_id => 19,
3141:
3142: IF nvl(l_x_master_item_return_status, FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3143: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
3144: l_msg_string:=FND_MESSAGE.GET;
3145: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3146: RAISE FND_API.G_EXC_ERROR;
3147:
3148: END IF;
3149:
3150:
3151: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3152: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
3153: l_msg_string:=FND_MESSAGE.GET;
3154: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3155: -- commented for BUG# 5484686
3156: RAISE FND_API.G_EXC_ERROR;
3157: END IF;
3158:
3161: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3162: -- ,p_data => x_msg_data);
3163: -- commented for BUG# 5484686
3164:
3165: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');
3166:
3167: EXCEPTION
3168: WHEN fnd_api.g_exc_error THEN
3169: ROLLBACK TO EAM_Activity_PUB;