[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;
202: WHERE organization_id = p_organization_id
203: AND wip_entity_id = p_wip_entity_id;
204:
205: BEGIN
206: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
207: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
208: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
209: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
203: AND wip_entity_id = p_wip_entity_id;
204:
205: BEGIN
206: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
207: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
208: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
209: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
204:
205: BEGIN
206: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
207: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
208: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
209: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
205: BEGIN
206: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
207: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
208: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
209: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
206: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
207: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
208: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
209: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
207: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
208: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
209: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
208: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
209: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
209: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
217:
210: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
217:
218:
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.inventory_item_id=' || p_target_item_rec.inventory_item_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
217:
218:
219: -- Create Operations
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.item_number=' || p_target_item_rec.item_number);
213: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_id=' || p_work_order_rec.organization_id);
214: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.organization_code=' || p_work_order_rec.organization_code);
215: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_id=' || p_work_order_rec.wip_entity_id);
216: EAM_ActivityUtilities_PVT.Write_Debug('p_work_order_rec.wip_entity_name=' || p_work_order_rec.wip_entity_name);
217:
218:
219: -- Create Operations
220: -- We need 1 Routing Header, table of Operations and Operation Networks, and table of Resources
242: l_operation_tbl(l_operation_tbl_index).Assembly_Item_Name := l_rtg_header_rec.Assembly_Item_Name;
243: l_operation_tbl(l_operation_tbl_index).Operation_Sequence_Number := l_wip_operation_row.Operation_Seq_Num;
244: l_operation_tbl(l_operation_tbl_index).Start_Effective_Date := l_effectivity_date;
245: l_operation_tbl(l_operation_tbl_index).Department_Code :=
246: EAM_ActivityUtilities_PVT.Get_Department_Code(l_wip_operation_row.Organization_Id,
247: l_wip_operation_row.department_id);
248: l_operation_tbl(l_operation_tbl_index).Operation_Description := l_wip_operation_row.Description;
249: l_operation_tbl(l_operation_tbl_index).Count_Point_Type := l_wip_operation_row.count_point_type;
250: l_operation_tbl(l_operation_tbl_index).Backflush_Flag := l_wip_operation_row.Backflush_Flag;
286: l_op_network_tbl(l_op_network_tbl_index).From_Start_Effective_Date := l_effectivity_date;
287: l_op_network_tbl(l_op_network_tbl_index).To_Op_Seq_Number := l_wip_op_network_row.Next_Operation;
288: l_op_network_tbl(l_op_network_tbl_index).To_Start_Effective_Date := l_effectivity_date;
289:
290: EAM_ActivityUtilities_PVT.Get_Op_Coordinates(
291: p_organization_id => p_work_order_rec.organization_id,
292: p_wip_entity_id => p_work_order_rec.wip_entity_id,
293: p_operation_seq_num => l_wip_op_network_row.Prior_Operation,
294: x_x_pos => l_x_pos,
296: );
297: l_op_network_tbl(l_op_network_tbl_index).From_X_Coordinate := l_x_pos;
298: l_op_network_tbl(l_op_network_tbl_index).From_Y_Coordinate := l_y_pos;
299:
300: EAM_ActivityUtilities_PVT.Get_Op_Coordinates(
301: p_organization_id => p_work_order_rec.organization_id,
302: p_wip_entity_id => p_work_order_rec.wip_entity_id,
303: p_operation_seq_num => l_wip_op_network_row.Next_Operation,
304: x_x_pos => l_x_pos,
347: l_op_resource_tbl(l_op_resource_tbl_index).Organization_Code := l_rtg_header_rec.Organization_Code;
348: l_op_resource_tbl(l_op_resource_tbl_index).Assembly_Item_Name := l_rtg_header_rec.Assembly_Item_Name;
349: l_op_resource_tbl(l_op_resource_tbl_index).Operation_Sequence_Number := l_wip_resource_row.Operation_Seq_Num;
350: l_op_resource_tbl(l_op_resource_tbl_index).Resource_Code :=
351: EAM_ActivityUtilities_PVT.Get_Resource_Code(l_wip_resource_row.Organization_Id,
352: l_wip_resource_row.Resource_Id);
353: l_op_resource_tbl(l_op_resource_tbl_index).Op_Start_Effective_Date := l_effectivity_date;
354: l_op_resource_tbl(l_op_resource_tbl_index).Resource_Sequence_Number := l_wip_resource_row.Resource_Seq_Num;
355:
359: l_wip_resource_row.Applied_Resource_Units;
360: ELSE
361: -- p_resource_copy_option = 3 (ALL)
362: l_op_resource_tbl(l_op_resource_tbl_index).Usage_Rate_Or_Amount :=
363: EAM_ActivityUtilities_PVT.Get_WO_Res_Scheduled_Units(
364: l_wip_resource_row.Organization_Id,
365: l_wip_resource_row.Wip_Entity_Id,
366: l_wip_resource_row.Operation_Seq_Num,
367: l_wip_resource_row.Resource_Seq_Num);
367: l_wip_resource_row.Resource_Seq_Num);
368: END IF;
369:
370: l_op_resource_tbl(l_op_resource_tbl_index).Activity :=
371: EAM_ActivityUtilities_PVT.Get_Cost_Activity(l_wip_resource_row.Activity_Id);
372: l_op_resource_tbl(l_op_resource_tbl_index).Schedule_Flag := l_wip_resource_row.Scheduled_Flag;
373: l_op_resource_tbl(l_op_resource_tbl_index).Assigned_Units := l_wip_resource_row.Assigned_Units;
374: l_op_resource_tbl(l_op_resource_tbl_index).Autocharge_Type := l_wip_resource_row.Autocharge_Type;
375: l_op_resource_tbl(l_op_resource_tbl_index).Standard_Rate_Flag := l_wip_resource_row.Standard_Rate_Flag;
404: -- Only Call Routing Business Object API if operation tabel is not empty
405: IF l_operation_tbl.FIRST IS NOT NULL THEN
406: Error_Handler.initialize;
407: -- log call to Process_Rtg API
408: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_RTG_PUB.Process_Rtg INPUT Parameters >>>>>>>>>>>>>>>');
409: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_rtg_header_rec,
410: l_operation_tbl,
411: l_op_resource_tbl,
412: l_op_network_tbl);
405: IF l_operation_tbl.FIRST IS NOT NULL THEN
406: Error_Handler.initialize;
407: -- log call to Process_Rtg API
408: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_RTG_PUB.Process_Rtg INPUT Parameters >>>>>>>>>>>>>>>');
409: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_rtg_header_rec,
410: l_operation_tbl,
411: l_op_resource_tbl,
412: l_op_network_tbl);
413:
410: l_operation_tbl,
411: l_op_resource_tbl,
412: l_op_network_tbl);
413:
414: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
415: BOM_RTG_PUB.Process_Rtg(
416: p_rtg_header_rec => l_rtg_header_rec
417: , p_operation_tbl => l_operation_tbl
418: , p_op_resource_tbl => l_op_resource_tbl
425: , x_op_network_tbl => l_x_op_network_tbl
426: , x_return_status => l_x_rtg_return_status
427: , x_msg_count => l_x_rtg_msg_count
428: );
429: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
430:
431: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
432:
433: -- log errors
430:
431: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
432:
433: -- log errors
434: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
435: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
431: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
432:
433: -- log errors
434: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
435: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
433: -- log errors
434: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
435: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
440: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
441: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
434: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
435: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
440: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
441: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
442: l_x_operation_tbl,
435: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
440: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
441: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
442: l_x_operation_tbl,
443: l_x_op_resource_tbl,
436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
440: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
441: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
442: l_x_operation_tbl,
443: l_x_op_resource_tbl,
444: l_x_op_network_tbl);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
440: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
441: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
442: l_x_operation_tbl,
443: l_x_op_resource_tbl,
444: l_x_op_network_tbl);
445:
455: x_rtg_msg_list := l_x_rtg_msg_list;
456:
457: END IF;
458:
459: EAM_ActivityUtilities_PVT.Write_Debug('---------- Exiting EAM_Activity_PUB.Create_Activity_Routing ----------');
460: END;
461:
462: -- ----------------------------------------------------------------------
463: PROCEDURE Create_Activity_BOM(
528: l_bom_component_tbl(l_bom_comp_tbl_index).Start_Effective_Date := l_effectivity_date;
529: l_bom_component_tbl(l_bom_comp_tbl_index).Operation_Sequence_Number :=
530: l_wip_requirement_row.Operation_Seq_Num;
531: l_bom_component_tbl(l_bom_comp_tbl_index).Component_Item_Name :=
532: EAM_ActivityUtilities_PVT.Get_Item_Concatenated_Segments(l_wip_requirement_row.organization_id,
533: l_wip_requirement_row.inventory_item_id);
534: -- l_bom_component_tbl(l_bom_comp_tbl_index).Item_Sequence_Number :=
535: -- l_wip_requirement_row.Component_Sequence_Id;
536: -- l_bom_component_tbl(l_bom_comp_tbl_index).Item_Sequence_Number := l_bom_comp_tbl_index;
547:
548: l_bom_component_tbl(l_bom_comp_tbl_index).Wip_Supply_Type := l_wip_requirement_row.Wip_Supply_Type;
549: l_bom_component_tbl(l_bom_comp_tbl_index).Supply_Subinventory := l_wip_requirement_row.Supply_Subinventory;
550: l_bom_component_tbl(l_bom_comp_tbl_index).Location_Name :=
551: EAM_ActivityUtilities_PVT.Get_Locator(l_wip_requirement_row.organization_id,
552: l_wip_requirement_row.Supply_Subinventory,
553: l_wip_requirement_row.Supply_Locator_Id);
554: l_bom_component_tbl(l_bom_comp_tbl_index).Attribute_Category := l_wip_requirement_row.Attribute_Category;
555: l_bom_component_tbl(l_bom_comp_tbl_index).Attribute1 := l_wip_requirement_row.Attribute1;
596: IF l_bom_component_tbl.FIRST IS NOT NULL THEN
597:
598: Error_Handler.initialize;
599: -- log call to Process_BOM API
600: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
601: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
602: l_bom_component_tbl);
603:
604: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
597:
598: Error_Handler.initialize;
599: -- log call to Process_BOM API
600: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
601: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
602: l_bom_component_tbl);
603:
604: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
605: BOM_BO_PUB.Process_BOM(
600: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
601: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
602: l_bom_component_tbl);
603:
604: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
605: BOM_BO_PUB.Process_BOM(
606: p_bom_header_rec => l_bom_head_rec,
607: p_bom_component_tbl => l_bom_component_tbl,
608: x_bom_header_rec => l_x_bom_header_rec,
612: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
613: x_return_status => l_x_bom_return_status,
614: x_msg_count => l_x_bom_msg_count
615: );
616: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
617:
618: Error_Handler.Get_Message_List(l_x_bom_msg_list);
619:
620: -- log errors
617:
618: Error_Handler.Get_Message_List(l_x_bom_msg_list);
619:
620: -- log errors
621: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
622: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
618: Error_Handler.Get_Message_List(l_x_bom_msg_list);
619:
620: -- log errors
621: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
622: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
620: -- log errors
621: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
622: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
628: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
621: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
622: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
628: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
629: l_x_bom_component_tbl);
622: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
628: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
629: l_x_bom_component_tbl);
630:
623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
628: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
629: l_x_bom_component_tbl);
630:
631:
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
628: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
629: l_x_bom_component_tbl);
630:
631:
632: -- Assign outputs.
703: -- Copy input activity record to a working record
704: l_item_rec := p_asset_activity;
705:
706: -- Validate org id and org code
707: EAM_ActivityUtilities_PVT.Validate_Organization(
708: p_organization_id => l_item_rec.organization_id,
709: p_organization_code => l_item_rec.organization_code,
710: x_return_status => l_validate_org_ret_sts,
711: x_organization_id => l_temp_org_id,
718: RAISE FND_API.G_EXC_ERROR;
719: END IF;
720:
721: -- ============================================================
722: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Create_Item --------');
723:
724: -- Save current org id
725: l_curr_organization_id := l_item_rec.organization_id;
726: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);
722: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Create_Item --------');
723:
724: -- Save current org id
725: l_curr_organization_id := l_item_rec.organization_id;
726: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);
727:
728: -- 2 a) Get master org id
729: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(l_curr_organization_id);
730: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
725: l_curr_organization_id := l_item_rec.organization_id;
726: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);
727:
728: -- 2 a) Get master org id
729: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(l_curr_organization_id);
730: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
731:
732: -- Set attributes of l_item_rec
733: l_item_rec.eam_item_type := 2; -- EAM Asset Activity
726: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);
727:
728: -- 2 a) Get master org id
729: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(l_curr_organization_id);
730: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
731:
732: -- Set attributes of l_item_rec
733: l_item_rec.eam_item_type := 2; -- EAM Asset Activity
734:
739:
740: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
741: THEN
742: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
743: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
744: END IF;
745: -- Check that expense_account is not null
746: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
747: THEN
746: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
747: THEN
748: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
749: -- FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
750: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
751: RAISE FND_API.G_EXC_ERROR;
752: END IF;
753:
754: IF l_item_rec.bom_enabled_flag IS NULL OR
762: -- set org to master org
763: l_item_rec.organization_id := l_master_organization_id;
764: l_item_rec.organization_code := NULL;
765:
766: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
767: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
768: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
769: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
770: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
763: l_item_rec.organization_id := l_master_organization_id;
764: l_item_rec.organization_code := NULL;
765:
766: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
767: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
768: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
769: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
770: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
771: INV_Item_GRP.Create_Item(
764: l_item_rec.organization_code := NULL;
765:
766: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
767: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
768: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
769: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
770: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
771: INV_Item_GRP.Create_Item(
772: p_Item_rec => l_item_rec,
765:
766: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
767: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
768: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
769: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
770: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
771: INV_Item_GRP.Create_Item(
772: p_Item_rec => l_item_rec,
773: p_Template_Id => p_template_id,
766: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
767: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
768: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
769: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
770: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
771: INV_Item_GRP.Create_Item(
772: p_Item_rec => l_item_rec,
773: p_Template_Id => p_template_id,
774: p_Template_Name => p_template_name,
781: x_master_item_return_status := l_x_master_item_return_status;
782: x_master_item_error_tbl := l_x_master_item_error_tbl;
783:
784: -- log outputs
785: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
787: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
782: x_master_item_error_tbl := l_x_master_item_error_tbl;
783:
784: -- log outputs
785: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
787: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
790: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
783:
784: -- log outputs
785: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
787: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
790: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
791:
784: -- log outputs
785: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
787: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
790: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
791:
792: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
785: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
787: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
790: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
791:
792: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: -- Create Item under master org fail, no use tyring to create it under child org.
786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
787: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
790: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
791:
792: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: -- Create Item under master org fail, no use tyring to create it under child org.
794: RETURN;
794: RETURN;
795: END IF;
796: ELSE
797: -- Current Org is Master Org, no additional Item needs to be created.
798: EAM_ActivityUtilities_PVT.Write_Debug('Current Org is Master Org, no additional Item needs to be created.');
799: x_master_item_rec := l_x_master_item_rec; -- should be NULL
800: x_master_item_return_status := FND_API.G_RET_STS_SUCCESS;
801: x_master_item_error_tbl := l_x_master_item_error_tbl; -- should be NULL
802: END IF;
807: l_item_rec.organization_code := NULL;
808: /*Bug3269789 - Added below code since master items form uses exp acct of child org
809: when assigning to child org*/
810: /*Bug#3269789 - start*/
811: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_curr_organization_id);
812:
813: -- Check that expense_account is not null
814: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
815: THEN
814: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
815: THEN
816: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
817: -- FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
818: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821: /*Bug#3269789 - end*/
822:
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821: /*Bug#3269789 - end*/
822:
823: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
824: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
825: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
826: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
827: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
820: END IF;
821: /*Bug#3269789 - end*/
822:
823: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
824: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
825: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
826: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
827: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
828: INV_Item_GRP.Create_Item(
821: /*Bug#3269789 - end*/
822:
823: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
824: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
825: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
826: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
827: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
828: INV_Item_GRP.Create_Item(
829: p_Item_rec => l_item_rec,
822:
823: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
824: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
825: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
826: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
827: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
828: INV_Item_GRP.Create_Item(
829: p_Item_rec => l_item_rec,
830: p_Template_Id => p_template_id,
823: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
824: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
825: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
826: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
827: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
828: INV_Item_GRP.Create_Item(
829: p_Item_rec => l_item_rec,
830: p_Template_Id => p_template_id,
831: p_Template_Name => p_template_name,
838: x_curr_item_return_status := l_x_curr_item_return_status;
839: x_curr_item_error_tbl := l_x_curr_item_error_tbl;
840:
841: -- log outputs
842: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
844: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
839: x_curr_item_error_tbl := l_x_curr_item_error_tbl;
840:
841: -- log outputs
842: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
844: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
840:
841: -- log outputs
842: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
844: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
848:
841: -- log outputs
842: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
844: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
848:
849: -- ============================================================
842: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
844: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
848:
849: -- ============================================================
850: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');
843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
844: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
848:
849: -- ============================================================
850: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');
851: END;
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
848:
849: -- ============================================================
850: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');
851: END;
852:
853: -- ======================================================================
854: PROCEDURE Create_Activity
977: x_return_status := FND_API.G_RET_STS_SUCCESS;
978: -- API body
979:
980: -- ============================================================
981: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
982: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
983: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
984: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
978: -- API body
979:
980: -- ============================================================
981: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
982: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
983: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
984: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
986: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
979:
980: -- ============================================================
981: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
982: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
983: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
984: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
986: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
987: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
980: -- ============================================================
981: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
982: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
983: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
984: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
986: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
987: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
988: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
981: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
982: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
983: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
984: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
986: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
987: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
988: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
989: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
982: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
983: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
984: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
986: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
987: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
988: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
989: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
990: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
983: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
984: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
986: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
987: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
988: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
989: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
990: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
991: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
984: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
986: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
987: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
988: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
989: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
990: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
991: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
992: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
986: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
987: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
988: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
989: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
990: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
991: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
992: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
993: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
986: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
987: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
988: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
989: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
990: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
991: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
992: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
993: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
994: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
987: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
988: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
989: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
990: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
991: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
992: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
993: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
994: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
995: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
988: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
989: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
990: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
991: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
992: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
993: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
994: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
995: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
996: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
989: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
990: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
991: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
992: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
993: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
994: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
995: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
996: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
997: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
990: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
991: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
992: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
993: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
994: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
995: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
996: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
997: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
998: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
991: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
992: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
993: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
994: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
995: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
996: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
997: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
998: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
999: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
992: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
993: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
994: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
995: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
996: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
997: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
998: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
999: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1000: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
993: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
994: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
995: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
996: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
997: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
998: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
999: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1000: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1001: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
994: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
995: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
996: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
997: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
998: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
999: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1000: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1001: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1002: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
995: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
996: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
997: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
998: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
999: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1000: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1001: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1002: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1003: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
996: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
997: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
998: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
999: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1000: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1001: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1002: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1003: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1004: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
997: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
998: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
999: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1000: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1001: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1002: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1003: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1004: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1005: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
998: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
999: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1000: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1001: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1002: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1003: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1004: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1005: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1006: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
999: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1000: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1001: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1002: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1003: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1004: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1005: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1006: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1007:
1000: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1001: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1002: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1003: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1004: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1005: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1006: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1007:
1008: -- ============================================================
1001: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1002: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1003: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1004: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1005: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1006: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1007:
1008: -- ============================================================
1009: -- Step 1: Validate inputs
1002: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1003: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1004: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1005: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1006: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1007:
1008: -- ============================================================
1009: -- Step 1: Validate inputs
1010: -- 1 a) Validate source Work Order
1007:
1008: -- ============================================================
1009: -- Step 1: Validate inputs
1010: -- 1 a) Validate source Work Order
1011: EAM_ActivityUtilities_PVT.Validate_Work_Order(
1012: p_work_order_rec => p_work_order_rec,
1013: x_return_status => l_x_work_order_ret_sts,
1014: x_work_order_rec => l_x_work_order_rec
1015: );
1057:
1058: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1059: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
1060: -- FND_MESSAGE.SET_ENCODED('Create Activity under Master Organization failed.');
1061: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;
1064:
1065: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1064:
1065: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1066: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
1067: -- FND_MESSAGE.SET_ENCODED('Create Activity under Current Organization failed.');
1068: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071:
1072: -- Set the Activity Attributes in the Item Record, don't have to do it manually
1159: -- Handle errors
1160: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1161: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');
1162: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1163: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166:
1167:
1193: -- Handle errors
1194: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1195: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1196: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1197: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1198: RAISE FND_API.G_EXC_ERROR;
1199: END IF;
1200:
1201:
1228: -- Handle error
1229: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1230: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ASSOC_FAILED');
1231: -- FND_MESSAGE.SET_ENCODED('Create Activity Associations failed.');
1232: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235:
1236: END IF;
1248: p_data => x_msg_data
1249: );
1250:
1251:
1252: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity ==========');
1253:
1254: -- ======================================================================
1255:
1256: EXCEPTION
1255:
1256: EXCEPTION
1257: WHEN FND_API.G_EXC_ERROR THEN
1258: ROLLBACK TO Create_Activity_PUB;
1259: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: EXPECTED_ERROR ==========');
1260: x_return_status := FND_API.G_RET_STS_ERROR ;
1261: FND_MSG_PUB.Count_And_Get
1262: ( p_count => x_msg_count ,
1263: p_data => x_msg_data
1263: p_data => x_msg_data
1264: );
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266: ROLLBACK TO Create_Activity_PUB;
1267: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: UNEXPECTED_ERROR ==========');
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1269: FND_MSG_PUB.Count_And_Get
1270: ( p_count => x_msg_count ,
1271: p_data => x_msg_data
1280: ( G_PKG_NAME ,
1281: l_api_name
1282: );
1283: -- log error message also
1284: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1285: END IF;
1286: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1287: FND_MSG_PUB.Count_And_Get
1288: ( p_count => x_msg_count ,
1282: );
1283: -- log error message also
1284: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1285: END IF;
1286: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1287: FND_MSG_PUB.Count_And_Get
1288: ( p_count => x_msg_count ,
1289: p_data => x_msg_data
1290: );
1419: x_return_status := FND_API.G_RET_STS_SUCCESS;
1420: -- API body
1421:
1422: -- ============================================================
1423: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1424: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1425: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1426: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1420: -- API body
1421:
1422: -- ============================================================
1423: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1424: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1425: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1426: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1428: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1421:
1422: -- ============================================================
1423: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1424: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1425: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1426: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1428: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1429: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1422: -- ============================================================
1423: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1424: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1425: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1426: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1428: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1429: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1430: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1423: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1424: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1425: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1426: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1428: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1429: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1430: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1431: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1424: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1425: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1426: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1428: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1429: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1430: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1431: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1432: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1425: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1426: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1428: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1429: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1430: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1431: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1432: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1433: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1426: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1428: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1429: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1430: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1431: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1432: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1433: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1434: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);
1428: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1429: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1430: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1431: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1432: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1433: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1434: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1435: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1428: EAM_ActivityUtilities_PVT.Write_Debug('Segment1=' || p_asset_activity.Segment1);
1429: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1430: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1431: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1432: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1433: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1434: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1435: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1436: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1429: EAM_ActivityUtilities_PVT.Write_Debug('Segment2=' || p_asset_activity.Segment2);
1430: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1431: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1432: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1433: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1434: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1435: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1436: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1437: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1430: EAM_ActivityUtilities_PVT.Write_Debug('Segment3=' || p_asset_activity.Segment3);
1431: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1432: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1433: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1434: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1435: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1436: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1437: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1438: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1431: EAM_ActivityUtilities_PVT.Write_Debug('Segment4=' || p_asset_activity.Segment4);
1432: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1433: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1434: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1435: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1436: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1437: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1438: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1439: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1432: EAM_ActivityUtilities_PVT.Write_Debug('Segment5=' || p_asset_activity.Segment5);
1433: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1434: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1435: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1436: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1437: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1438: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1439: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1440: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1433: EAM_ActivityUtilities_PVT.Write_Debug('Segment6=' || p_asset_activity.Segment6);
1434: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1435: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1436: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1437: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1438: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1439: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1440: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1441: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1434: EAM_ActivityUtilities_PVT.Write_Debug('Segment7=' || p_asset_activity.Segment7);
1435: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1436: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1437: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1438: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1439: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1440: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1441: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1442: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1435: EAM_ActivityUtilities_PVT.Write_Debug('Segment8=' || p_asset_activity.Segment8);
1436: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1437: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1438: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1439: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1440: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1441: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1442: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1443: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1436: EAM_ActivityUtilities_PVT.Write_Debug('Segment9=' || p_asset_activity.Segment9);
1437: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1438: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1439: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1440: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1441: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1442: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1443: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1444: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1437: EAM_ActivityUtilities_PVT.Write_Debug('Segment10=' || p_asset_activity.Segment10);
1438: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1439: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1440: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1441: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1442: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1443: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1444: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1445: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1438: EAM_ActivityUtilities_PVT.Write_Debug('Segment11=' || p_asset_activity.Segment11);
1439: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1440: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1441: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1442: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1443: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1444: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1445: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1446: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1439: EAM_ActivityUtilities_PVT.Write_Debug('Segment12=' || p_asset_activity.Segment12);
1440: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1441: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1442: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1443: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1444: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1445: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1446: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1447: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1440: EAM_ActivityUtilities_PVT.Write_Debug('Segment13=' || p_asset_activity.Segment13);
1441: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1442: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1443: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1444: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1445: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1446: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1447: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1448: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1441: EAM_ActivityUtilities_PVT.Write_Debug('Segment14=' || p_asset_activity.Segment14);
1442: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1443: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1444: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1445: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1446: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1447: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1448: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1449:
1442: EAM_ActivityUtilities_PVT.Write_Debug('Segment15=' || p_asset_activity.Segment15);
1443: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1444: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1445: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1446: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1447: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1448: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1449:
1450: -- ============================================================
1443: EAM_ActivityUtilities_PVT.Write_Debug('Segment16=' || p_asset_activity.Segment16);
1444: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1445: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1446: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1447: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1448: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1449:
1450: -- ============================================================
1451: -- Step 1: Validate inputs
1444: EAM_ActivityUtilities_PVT.Write_Debug('Segment17=' || p_asset_activity.Segment17);
1445: EAM_ActivityUtilities_PVT.Write_Debug('Segment18=' || p_asset_activity.Segment18);
1446: EAM_ActivityUtilities_PVT.Write_Debug('Segment19=' || p_asset_activity.Segment19);
1447: EAM_ActivityUtilities_PVT.Write_Debug('Segment20=' || p_asset_activity.Segment20);
1448: EAM_ActivityUtilities_PVT.Write_Debug('Description=' || p_asset_activity.Description);
1449:
1450: -- ============================================================
1451: -- Step 1: Validate inputs
1452: -- 1 a) Validate ???
1486:
1487: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1488: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
1489: -- FND_MESSAGE.SET_ENCODED('Create Activity under Master Organization failed.');
1490: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1491: RAISE FND_API.G_EXC_ERROR;
1492: END IF;
1493:
1494: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1493:
1494: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1495: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
1496: -- FND_MESSAGE.SET_ENCODED('Create Activity under Current Organization failed.');
1497: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1498: RAISE FND_API.G_EXC_ERROR;
1499: END IF;
1500:
1501: -- Set the Activity Attributes in the Item Record, don't have to do it manually
1560: -- Bug # 3662214 : Need to create Routing first and then BOM so
1561: -- that operation sequence number in BOM is retained.
1562:
1563: -- Step 3: Copy Routing
1564: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Routing --------');
1565:
1566: -- 3 a) Check Routing Copy Option
1567: EAM_ActivityUtilities_PVT.Write_Debug('p_routing_copy_option=' || p_routing_copy_option);
1568: IF p_routing_copy_option = 2 THEN
1563: -- Step 3: Copy Routing
1564: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Routing --------');
1565:
1566: -- 3 a) Check Routing Copy Option
1567: EAM_ActivityUtilities_PVT.Write_Debug('p_routing_copy_option=' || p_routing_copy_option);
1568: IF p_routing_copy_option = 2 THEN
1569:
1570: -- 3 b) Check if Source has Routing (sequence id)
1571: l_source_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1567: EAM_ActivityUtilities_PVT.Write_Debug('p_routing_copy_option=' || p_routing_copy_option);
1568: IF p_routing_copy_option = 2 THEN
1569:
1570: -- 3 b) Check if Source has Routing (sequence id)
1571: l_source_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1572: p_organization_id => p_source_org_id,
1573: p_assembly_item_id => p_source_activity_id,
1574: p_alternate_rtg_designator => p_source_alt_rtg_designator);
1575: EAM_ActivityUtilities_PVT.Write_Debug('l_source_rtg_sequence_id=' || l_source_rtg_sequence_id);
1571: l_source_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1572: p_organization_id => p_source_org_id,
1573: p_assembly_item_id => p_source_activity_id,
1574: p_alternate_rtg_designator => p_source_alt_rtg_designator);
1575: EAM_ActivityUtilities_PVT.Write_Debug('l_source_rtg_sequence_id=' || l_source_rtg_sequence_id);
1576:
1577: IF l_source_rtg_sequence_id IS NULL THEN
1578: -- Source Activity does not have Routing, nothing to copy
1579: NULL;
1588: l_rtg_header_rec.Organization_Code := l_x_curr_item_rec.Organization_Code;
1589:
1590: Error_Handler.initialize;
1591: -- log call to Process_Rtg API
1592: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
1593: BOM_RTG_PUB.Process_Rtg(
1594: p_rtg_header_rec => l_rtg_header_rec
1595: , x_rtg_header_rec => l_x_rtg_header_rec
1596: , x_rtg_revision_tbl => l_x_rtg_revision_tbl
1600: , x_op_network_tbl => l_x_op_network_tbl
1601: , x_return_status => l_x_rtg_return_status
1602: , x_msg_count => l_x_rtg_msg_count
1603: );
1604: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
1605:
1606: -- log errors
1607: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1603: );
1604: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
1605:
1606: -- log errors
1607: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1609: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1610: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1611: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1604: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
1605:
1606: -- log errors
1607: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1609: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1610: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1611: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1612: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1606: -- log errors
1607: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1609: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1610: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1611: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1612: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1613:
1614: -- Handle errors
1607: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1609: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1610: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1611: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1612: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1613:
1614: -- Handle errors
1615: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1609: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1610: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1611: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1612: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1613:
1614: -- Handle errors
1615: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1616: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1614: -- Handle errors
1615: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1616: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1617: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1618: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1619: RAISE FND_API.G_EXC_ERROR;
1620: END IF;
1621:
1622: l_target_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1618: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1619: RAISE FND_API.G_EXC_ERROR;
1620: END IF;
1621:
1622: l_target_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1623: p_organization_id => l_x_curr_item_rec.organization_id,
1624: p_assembly_item_id => l_x_curr_item_rec.inventory_item_id,
1625: p_alternate_rtg_designator => NULL);
1626: EAM_ActivityUtilities_PVT.Write_Debug('l_target_rtg_sequence_id=' || l_target_rtg_sequence_id);
1622: l_target_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(
1623: p_organization_id => l_x_curr_item_rec.organization_id,
1624: p_assembly_item_id => l_x_curr_item_rec.inventory_item_id,
1625: p_alternate_rtg_designator => NULL);
1626: EAM_ActivityUtilities_PVT.Write_Debug('l_target_rtg_sequence_id=' || l_target_rtg_sequence_id);
1627:
1628: -- 4 d) Call copy_routing API
1629: -- log call to copy_routing API
1630: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_COPY_ROUTING.copy_routing **********');
1626: EAM_ActivityUtilities_PVT.Write_Debug('l_target_rtg_sequence_id=' || l_target_rtg_sequence_id);
1627:
1628: -- 4 d) Call copy_routing API
1629: -- log call to copy_routing API
1630: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_COPY_ROUTING.copy_routing **********');
1631: BOM_COPY_ROUTING.copy_routing(
1632: to_sequence_id => l_target_rtg_sequence_id,
1633: from_sequence_id => l_source_rtg_sequence_id,
1634: from_org_id => p_source_org_id,
1638: direction => 1,
1639: to_alternate => NULL,
1640: rev_date => p_source_rtg_rev_date
1641: );
1642: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_ROUTING.copy_routing **********');
1643:
1644: -- write copy_routing error message to fnd message stack and log file
1645: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1646: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1641: );
1642: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_ROUTING.copy_routing **********');
1643:
1644: -- write copy_routing error message to fnd message stack and log file
1645: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1646: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1647: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_ROUTING.copy_routing <<<<<');
1648:
1649: END IF; -- l_source_rtg_sequence_id IS NULL
1642: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_ROUTING.copy_routing **********');
1643:
1644: -- write copy_routing error message to fnd message stack and log file
1645: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1646: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1647: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_ROUTING.copy_routing <<<<<');
1648:
1649: END IF; -- l_source_rtg_sequence_id IS NULL
1650:
1643:
1644: -- write copy_routing error message to fnd message stack and log file
1645: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1646: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1647: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_ROUTING.copy_routing <<<<<');
1648:
1649: END IF; -- l_source_rtg_sequence_id IS NULL
1650:
1651: END IF; -- p_routing_copy_option
1649: END IF; -- l_source_rtg_sequence_id IS NULL
1650:
1651: END IF; -- p_routing_copy_option
1652:
1653: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy Routing --------');
1654:
1655: -- ============================================================
1656: -- Step 4: Copy BOM
1657: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy BOM --------');
1653: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy Routing --------');
1654:
1655: -- ============================================================
1656: -- Step 4: Copy BOM
1657: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy BOM --------');
1658:
1659: -- 4 a) Check BOM Copy Option
1660: EAM_ActivityUtilities_PVT.Write_Debug('p_bom_copy_option=' || p_bom_copy_option);
1661: IF p_bom_copy_option = 2 THEN
1656: -- Step 4: Copy BOM
1657: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy BOM --------');
1658:
1659: -- 4 a) Check BOM Copy Option
1660: EAM_ActivityUtilities_PVT.Write_Debug('p_bom_copy_option=' || p_bom_copy_option);
1661: IF p_bom_copy_option = 2 THEN
1662:
1663: -- 4 b) Check if Source has BOM (sequence_id)
1664: l_source_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1660: EAM_ActivityUtilities_PVT.Write_Debug('p_bom_copy_option=' || p_bom_copy_option);
1661: IF p_bom_copy_option = 2 THEN
1662:
1663: -- 4 b) Check if Source has BOM (sequence_id)
1664: l_source_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1665: p_organization_id => p_source_org_id,
1666: p_assembly_item_id => p_source_activity_id,
1667: p_alternate_bom_designator => p_source_alt_bom_designator);
1668: EAM_ActivityUtilities_PVT.Write_Debug('l_source_bom_sequence_id=' || l_source_bom_sequence_id);
1664: l_source_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1665: p_organization_id => p_source_org_id,
1666: p_assembly_item_id => p_source_activity_id,
1667: p_alternate_bom_designator => p_source_alt_bom_designator);
1668: EAM_ActivityUtilities_PVT.Write_Debug('l_source_bom_sequence_id=' || l_source_bom_sequence_id);
1669:
1670: IF l_source_bom_sequence_id IS NULL THEN
1671: -- Source Activity does not have BOM, nothing to copy
1672: NULL;
1681:
1682: -- Create empty BOM header through BOM Business Object API
1683: Error_Handler.initialize;
1684: -- log call to Process_BOM API
1685: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
1686: BOM_BO_PUB.Process_BOM(
1687: p_bom_header_rec => l_bom_head_rec,
1688: x_bom_header_rec => l_x_bom_header_rec,
1689: x_bom_revision_tbl => l_x_bom_revision_tbl,
1692: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
1693: x_return_status => l_x_bom_return_status,
1694: x_msg_count => l_x_bom_msg_count
1695: );
1696: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
1697:
1698: -- log errors
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1695: );
1696: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
1697:
1698: -- log errors
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1701: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1702: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1703: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1696: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
1697:
1698: -- log errors
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1701: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1702: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1703: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1704: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1698: -- log errors
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1701: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1702: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1703: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1704: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1705:
1706: -- Handle errors
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1701: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1702: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1703: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1704: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1705:
1706: -- Handle errors
1707: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1701: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1702: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1703: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1704: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1705:
1706: -- Handle errors
1707: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1708: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');
1706: -- Handle errors
1707: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1708: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');
1709: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1710: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1711: RAISE FND_API.G_EXC_ERROR;
1712: END IF;
1713:
1714: l_target_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1710: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1711: RAISE FND_API.G_EXC_ERROR;
1712: END IF;
1713:
1714: l_target_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1715: p_organization_id => l_x_curr_item_rec.organization_id,
1716: p_assembly_item_id => l_x_curr_item_rec.inventory_item_id,
1717: p_alternate_bom_designator => NULL);
1718: EAM_ActivityUtilities_PVT.Write_Debug('l_target_bom_sequence_id=' || l_target_bom_sequence_id);
1714: l_target_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(
1715: p_organization_id => l_x_curr_item_rec.organization_id,
1716: p_assembly_item_id => l_x_curr_item_rec.inventory_item_id,
1717: p_alternate_bom_designator => NULL);
1718: EAM_ActivityUtilities_PVT.Write_Debug('l_target_bom_sequence_id=' || l_target_bom_sequence_id);
1719:
1720: -- 3 d) Call copy_bill API
1721: -- log call to copy_bill API
1722: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_COPY_BILL.copy_bill **********');
1718: EAM_ActivityUtilities_PVT.Write_Debug('l_target_bom_sequence_id=' || l_target_bom_sequence_id);
1719:
1720: -- 3 d) Call copy_bill API
1721: -- log call to copy_bill API
1722: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_COPY_BILL.copy_bill **********');
1723: BOM_COPY_BILL.copy_bill(
1724: to_sequence_id => l_target_bom_sequence_id,
1725: from_sequence_id => l_source_bom_sequence_id,
1726: from_org_id => p_source_org_id,
1735: bill_or_eco => 1,
1736: eco_eff_date => NULL,
1737: from_item_id => p_source_activity_id
1738: );
1739: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_BILL.copy_bill **********');
1740:
1741: -- write copy_bill error message to fnd message stack and log file
1742: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1743: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1738: );
1739: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_BILL.copy_bill **********');
1740:
1741: -- write copy_bill error message to fnd message stack and log file
1742: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1743: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1744: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_BILL.copy_bill <<<<<');
1745:
1746:
1739: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_BILL.copy_bill **********');
1740:
1741: -- write copy_bill error message to fnd message stack and log file
1742: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1743: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1744: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_BILL.copy_bill <<<<<');
1745:
1746:
1747: END IF; -- l_source_bom_sequence_id IS NULL
1740:
1741: -- write copy_bill error message to fnd message stack and log file
1742: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1743: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1744: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_BILL.copy_bill <<<<<');
1745:
1746:
1747: END IF; -- l_source_bom_sequence_id IS NULL
1748:
1747: END IF; -- l_source_bom_sequence_id IS NULL
1748:
1749: END IF; -- p_bom_copy_option = 2
1750:
1751: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy BOM --------');
1752:
1753: -- ============================================================
1754: -- Step 5: Update Association to Asset Numbers for the newly created activity
1755: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Association --------');
1751: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy BOM --------');
1752:
1753: -- ============================================================
1754: -- Step 5: Update Association to Asset Numbers for the newly created activity
1755: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Association --------');
1756:
1757: EAM_ActivityUtilities_PVT.Write_Debug('p_association_copy_option=' || p_association_copy_option);
1758: IF p_association_copy_option <> 1 THEN
1759: -- p_association_copy_option <> 1 (NONE), call private package to create association
1753: -- ============================================================
1754: -- Step 5: Update Association to Asset Numbers for the newly created activity
1755: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Association --------');
1756:
1757: EAM_ActivityUtilities_PVT.Write_Debug('p_association_copy_option=' || p_association_copy_option);
1758: IF p_association_copy_option <> 1 THEN
1759: -- p_association_copy_option <> 1 (NONE), call private package to create association
1760: EAM_ActivityUtilities_PVT.Write_Debug(
1761: '********** Calling EAM_ActivityAssociation_PVT.Create_Association **********');
1756:
1757: EAM_ActivityUtilities_PVT.Write_Debug('p_association_copy_option=' || p_association_copy_option);
1758: IF p_association_copy_option <> 1 THEN
1759: -- p_association_copy_option <> 1 (NONE), call private package to create association
1760: EAM_ActivityUtilities_PVT.Write_Debug(
1761: '********** Calling EAM_ActivityAssociation_PVT.Create_Association **********');
1762: EAM_ActivityAssociation_PVT.Create_Association(
1763: p_api_version => 1.0,
1764: x_return_status => l_x_assoc_return_status,
1774:
1775: x_act_num_association_tbl => l_x_act_num_association_tbl,
1776: x_activity_association_tbl => l_x_activity_association_tbl
1777: );
1778: EAM_ActivityUtilities_PVT.Write_Debug(
1779: '********** Returned from EAM_ActivityAssociation_PVT.Create_Association **********');
1780: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_return_status=' || l_x_assoc_return_status);
1781: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_count=' || l_x_assoc_msg_count);
1782: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_data=' || l_x_assoc_msg_data);
1776: x_activity_association_tbl => l_x_activity_association_tbl
1777: );
1778: EAM_ActivityUtilities_PVT.Write_Debug(
1779: '********** Returned from EAM_ActivityAssociation_PVT.Create_Association **********');
1780: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_return_status=' || l_x_assoc_return_status);
1781: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_count=' || l_x_assoc_msg_count);
1782: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_data=' || l_x_assoc_msg_data);
1783:
1784: -- Assing outputs
1777: );
1778: EAM_ActivityUtilities_PVT.Write_Debug(
1779: '********** Returned from EAM_ActivityAssociation_PVT.Create_Association **********');
1780: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_return_status=' || l_x_assoc_return_status);
1781: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_count=' || l_x_assoc_msg_count);
1782: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_data=' || l_x_assoc_msg_data);
1783:
1784: -- Assing outputs
1785: x_assoc_return_status := l_x_assoc_return_status;
1778: EAM_ActivityUtilities_PVT.Write_Debug(
1779: '********** Returned from EAM_ActivityAssociation_PVT.Create_Association **********');
1780: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_return_status=' || l_x_assoc_return_status);
1781: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_count=' || l_x_assoc_msg_count);
1782: EAM_ActivityUtilities_PVT.Write_Debug('l_x_assoc_msg_data=' || l_x_assoc_msg_data);
1783:
1784: -- Assing outputs
1785: x_assoc_return_status := l_x_assoc_return_status;
1786: x_assoc_msg_count := l_x_assoc_msg_count;
1791: -- Handle error
1792: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1793: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ASSOC_FAILED');
1794: -- FND_MESSAGE.SET_ENCODED('Create Activity Associations failed.');
1795: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1796: RAISE FND_API.G_EXC_ERROR;
1797: END IF;
1798:
1799: END IF;
1797: END IF;
1798:
1799: END IF;
1800:
1801: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished Copy Association --------');
1802:
1803: -- ======================================================================
1804:
1805:
1813: ( p_count => x_msg_count ,
1814: p_data => x_msg_data
1815: );
1816:
1817: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Copy_Activity ==========');
1818:
1819:
1820: -- ======================================================================
1821: EXCEPTION
1820: -- ======================================================================
1821: EXCEPTION
1822: WHEN FND_API.G_EXC_ERROR THEN
1823: ROLLBACK TO Copy_Activity_PUB;
1824: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: EXPECTED_ERROR ==========');
1825: x_return_status := FND_API.G_RET_STS_ERROR ;
1826: FND_MSG_PUB.Count_And_Get
1827: ( p_count => x_msg_count ,
1828: p_data => x_msg_data
1828: p_data => x_msg_data
1829: );
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: ROLLBACK TO Copy_Activity_PUB;
1832: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: UNEXPECTED_ERROR ==========');
1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1834: FND_MSG_PUB.Count_And_Get
1835: ( p_count => x_msg_count ,
1836: p_data => x_msg_data
1846: ( G_PKG_NAME ,
1847: l_api_name
1848: );
1849: -- log error message also
1850: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1851: END IF;
1852: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1853: FND_MSG_PUB.Count_And_Get
1854: ( p_count => x_msg_count ,
1848: );
1849: -- log error message also
1850: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1851: END IF;
1852: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1853: FND_MSG_PUB.Count_And_Get
1854: ( p_count => x_msg_count ,
1855: p_data => x_msg_data
1856: );
1947: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1948:
1949: BEGIN
1950:
1951: EAM_ActivityUtilities_PVT.Open_Debug_Session;
1952:
1953: -- 1: Step up activity parameters
1954: l_work_order_rec.wip_entity_id := p_wip_entity_id;
1955: l_asset_activity.Description := p_description;
2072: ELSE
2073: x_successful := FALSE;
2074: END IF;
2075:
2076: EAM_ActivityUtilities_PVT.Close_Debug_Session;
2077:
2078: END Create_Activity_From_Form;
2079:
2080:
2164: x_return_status := FND_API.G_RET_STS_SUCCESS;
2165: -- API body
2166:
2167: -- ============================================================
2168: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2169: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2170: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2171: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2165: -- API body
2166:
2167: -- ============================================================
2168: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2169: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2170: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2171: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2173: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2166:
2167: -- ============================================================
2168: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2169: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2170: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2171: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2173: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2174: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2167: -- ============================================================
2168: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2169: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2170: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2171: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2173: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2174: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2175: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2168: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2169: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2170: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2171: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2173: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2174: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2175: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2176: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2169: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2170: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2171: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2173: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2174: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2175: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2176: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2177: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2170: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2171: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2173: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2174: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2175: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2176: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2177: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2178: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2171: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2173: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2174: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2175: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2176: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2177: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2178: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2179: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);
2173: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2174: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2175: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2176: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2177: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2178: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2179: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2180: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2173: EAM_ActivityUtilities_PVT.Write_Debug('p_segment2=' || p_segment2);
2174: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2175: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2176: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2177: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2178: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2179: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2180: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2181: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2174: EAM_ActivityUtilities_PVT.Write_Debug('p_segment3=' || p_segment3);
2175: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2176: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2177: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2178: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2179: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2180: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2181: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2182: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2175: EAM_ActivityUtilities_PVT.Write_Debug('p_segment4=' || p_segment4);
2176: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2177: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2178: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2179: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2180: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2181: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2182: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2183: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2176: EAM_ActivityUtilities_PVT.Write_Debug('p_segment5=' || p_segment5);
2177: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2178: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2179: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2180: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2181: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2182: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2183: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2184: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2177: EAM_ActivityUtilities_PVT.Write_Debug('p_segment6=' || p_segment6);
2178: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2179: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2180: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2181: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2182: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2183: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2184: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2185: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2178: EAM_ActivityUtilities_PVT.Write_Debug('p_segment7=' || p_segment7);
2179: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2180: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2181: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2182: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2183: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2184: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2185: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2186: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2179: EAM_ActivityUtilities_PVT.Write_Debug('p_segment8=' || p_segment8);
2180: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2181: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2182: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2183: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2184: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2185: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2186: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2187: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2180: EAM_ActivityUtilities_PVT.Write_Debug('p_segment9=' || p_segment9);
2181: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2182: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2183: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2184: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2185: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2186: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2187: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2188: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2181: EAM_ActivityUtilities_PVT.Write_Debug('p_segment10=' || p_segment10);
2182: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2183: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2184: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2185: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2186: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2187: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2188: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2189: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2182: EAM_ActivityUtilities_PVT.Write_Debug('p_segment11=' || p_segment11);
2183: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2184: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2185: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2186: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2187: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2188: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2189: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2190: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2183: EAM_ActivityUtilities_PVT.Write_Debug('p_segment12=' || p_segment12);
2184: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2185: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2186: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2187: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2188: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2189: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2190: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2191: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2184: EAM_ActivityUtilities_PVT.Write_Debug('p_segment13=' || p_segment13);
2185: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2186: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2187: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2188: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2189: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2190: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2191: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2192: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2185: EAM_ActivityUtilities_PVT.Write_Debug('p_segment14=' || p_segment14);
2186: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2187: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2188: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2189: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2190: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2191: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2192: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2193:
2186: EAM_ActivityUtilities_PVT.Write_Debug('p_segment15=' || p_segment15);
2187: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2188: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2189: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2190: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2191: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2192: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2193:
2194: -- ============================================================
2187: EAM_ActivityUtilities_PVT.Write_Debug('p_segment16=' || p_segment16);
2188: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2189: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2190: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2191: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2192: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2193:
2194: -- ============================================================
2195: -- Create Asset Activity. Call INV_Item_GRP package.
2188: EAM_ActivityUtilities_PVT.Write_Debug('p_segment17=' || p_segment17);
2189: EAM_ActivityUtilities_PVT.Write_Debug('p_segment18=' || p_segment18);
2190: EAM_ActivityUtilities_PVT.Write_Debug('p_segment19=' || p_segment19);
2191: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2192: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2193:
2194: -- ============================================================
2195: -- Create Asset Activity. Call INV_Item_GRP package.
2196:
2275: x_master_item_error_tbl := l_x_master_item_error_tbl;
2276:
2277: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2278: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
2279: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
2280: RAISE FND_API.G_EXC_ERROR;
2281: END IF;
2282:
2283: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2281: END IF;
2282:
2283: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2284: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
2285: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288:
2289: -- =============================================================
2299: p_data => x_msg_data
2300: );
2301:
2302:
2303: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity_With_Template ==========');
2304:
2305: -- ======================================================================
2306:
2307: EXCEPTION
2306:
2307: EXCEPTION
2308: WHEN FND_API.G_EXC_ERROR THEN
2309: ROLLBACK TO Create_Act_With_Templ_PUB;
2310: EAM_ActivityUtilities_PVT.Write_Debug(
2311: '========== EAM_Activity_PUB.Create_Activity_With_Template: EXPECTED ERROR ==========');
2312: x_return_status := FND_API.G_RET_STS_ERROR ;
2313: FND_MSG_PUB.Count_And_Get
2314: ( p_count => x_msg_count ,
2315: p_data => x_msg_data
2316: );
2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2318: ROLLBACK TO Create_Act_With_Templ_PUB;
2319: EAM_ActivityUtilities_PVT.Write_Debug(
2320: '========== EAM_Activity_PUB.Create_Activity_With_Template: UNEXPECTED ERROR ==========');
2321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2322: FND_MSG_PUB.Count_And_Get
2323: ( p_count => x_msg_count ,
2324: p_data => x_msg_data
2325: );
2326: WHEN OTHERS THEN
2327: ROLLBACK TO Create_Act_With_Templ_PUB;
2328: EAM_ActivityUtilities_PVT.Write_Debug(
2329: '========== EAM_Activity_PUB.Create_Activity_With_Template: OTHER ERROR ==========');
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2331: IF FND_MSG_PUB.Check_Msg_Level
2332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2409: */
2410: --l_bom_head_rec.Alternate_Bom_Code := l_bom_bom_row.alternate_bom_designator;
2411: --l_bom_head_rec.Assembly_Type := l_bom_bom_row.assembly_type;
2412: -- log call to Process_BOM API
2413: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
2414: BOM_BO_PUB.Process_BOM(
2415: p_bom_header_rec => l_bom_head_rec,
2416: p_bom_component_tbl => l_bom_component_tbl,
2417: x_bom_header_rec => l_x_bom_header_rec,
2421: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
2422: x_return_status => l_x_bom_return_status,
2423: x_msg_count => l_x_bom_msg_count
2424: );
2425: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
2426:
2427: x_bom_header_rec := l_x_bom_header_rec;
2428: x_bom_revision_tbl := l_x_bom_revision_tbl;
2429: x_bom_component_tbl := l_x_bom_component_tbl;
2545: begin
2546:
2547:
2548: -- ============================================================
2549: EAM_ActivityUtilities_PVT.Open_Debug_Session;
2550:
2551: create_activity_with_template(
2552: p_api_version => l_api_version,
2553: p_init_msg_list => l_init_msg_list,
2606: x_success := FALSE;
2607: end if;*/
2608:
2609: -- ============================================================
2610: EAM_ActivityUtilities_PVT.Close_Debug_Session;
2611:
2612: end create_activity_with_template;
2613:
2614: PROCEDURE Create_Routing_Header(
2658: l_rtg_header_rec.Transaction_Type := l_create_txn_type;
2659:
2660: Error_Handler.initialize;
2661: -- log call to Process_Rtg API
2662: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
2663: BOM_RTG_PUB.Process_Rtg(
2664: p_rtg_header_rec => l_rtg_header_rec
2665: , p_operation_tbl => l_operation_tbl
2666: , p_op_resource_tbl => l_op_resource_tbl
2673: , x_op_network_tbl => l_x_op_network_tbl
2674: , x_return_status => l_x_rtg_return_status
2675: , x_msg_count => l_x_rtg_msg_count
2676: );
2677: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
2678:
2679: -- Assign outputs.
2680: x_rtg_header_rec := l_x_rtg_header_rec;
2681: x_rtg_revision_tbl := l_x_rtg_revision_tbl;
2810: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2811: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2812: begin
2813:
2814: EAM_ActivityUtilities_PVT.Open_Debug_Session;
2815:
2816: -- Set up Item Number. Use segments if specified.
2817: IF p_segment1 IS NOT NULL OR
2818: p_segment2 IS NOT NULL OR
2910: x_act_num_association_tbl => l_x_act_num_association_tbl ,
2911: x_activity_association_tbl => l_x_activity_association_tbl
2912: );
2913:
2914: EAM_ActivityUtilities_PVT.Close_Debug_Session;
2915:
2916: end Copy_Activity;
2917:
2918:
2949:
2950: BEGIN
2951: SAVEPOINT EAM_Activity_PUB;
2952: -- Standard call to check for call compatibility.
2953: --EAM_ActivityUtilities_PVT.Open_Debug_Session;
2954: IF NOT fnd_api.compatible_api_call(
2955: l_api_version
2956: ,p_api_version
2957: ,l_api_name
2964: fnd_msg_pub.initialize;
2965: END IF;
2966: */
2967: -- Get master org id
2968: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(p_org_id);
2969: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
2970:
2971: BEGIN
2972: -- check if the activity exists in Master organization
2965: END IF;
2966: */
2967: -- Get master org id
2968: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(p_org_id);
2969: EAM_ActivityUtilities_PVT.Write_Debug('l_master_organization_id=' || l_master_organization_id);
2970:
2971: BEGIN
2972: -- check if the activity exists in Master organization
2973: SELECT segment1, segment2, segment3, segment4, segment5, segment6, segment7,
2988: WHERE organization_id = l_master_organization_id
2989: AND inventory_item_id = p_activity_id;
2990:
2991: -- Validate org id and org code
2992: EAM_ActivityUtilities_PVT.Validate_Organization(
2993: p_organization_id => p_org_id,
2994: p_organization_code => l_item_rec.organization_code,
2995: x_return_status => l_x_return_status,
2996: x_organization_id => l_item_rec.organization_id,
3002: RAISE FND_API.G_EXC_ERROR;
3003: END IF;
3004:
3005: -- ============================================================
3006: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Activity_org_assign --------');
3007:
3008:
3009: IF l_item_rec.inventory_item_flag IS NULL OR
3010: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN
3012: END IF;
3013: /*
3014: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3015: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
3016: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
3017: END IF;
3018: -- Check that expense_account is not null
3019: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3020: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
3018: -- Check that expense_account is not null
3019: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3020: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
3021: --FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
3022: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3023:
3024: RAISE FND_API.G_EXC_ERROR;
3025:
3026: END IF;
3030: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR THEN
3031: l_item_rec.bom_enabled_flag := 'Y';
3032: END IF;
3033:
3034: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3035: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3036:
3037:
3038: INV_Item_GRP.Create_Item
3031: l_item_rec.bom_enabled_flag := 'Y';
3032: END IF;
3033:
3034: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3035: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3036:
3037:
3038: INV_Item_GRP.Create_Item
3039: (
3051: x_error_msg_new=>l_error_string
3052: );
3053:
3054: -- log outputs
3055: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3057: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3052: );
3053:
3054: -- log outputs
3055: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3057: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3060: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3053:
3054: -- log outputs
3055: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3057: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3060: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3061:
3054: -- log outputs
3055: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3057: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3060: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3061:
3062: EXCEPTION
3055: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3057: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3060: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3061:
3062: EXCEPTION
3063: WHEN NO_DATA_FOUND THEN
3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3057: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3060: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3061:
3062: EXCEPTION
3063: WHEN NO_DATA_FOUND THEN
3064: -- There is no record in master org... so create in both ...
3080: WHERE inventory_item_id = p_activity_id
3081: AND ROWNUM = 1;
3082:
3083: l_item_rec.organization_id := p_org_id;
3084: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
3085: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3086: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3087:
3088: Create_Item(
3081: AND ROWNUM = 1;
3082:
3083: l_item_rec.organization_id := p_org_id;
3084: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
3085: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3086: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3087:
3088: Create_Item(
3089: p_asset_activity => l_item_rec,
3082:
3083: l_item_rec.organization_id := p_org_id;
3084: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
3085: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3086: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3087:
3088: Create_Item(
3089: p_asset_activity => l_item_rec,
3090: p_template_id => 19,
3110:
3111: IF nvl(l_x_master_item_return_status, FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3112: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
3113: l_msg_string:=FND_MESSAGE.GET;
3114: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3115: RAISE FND_API.G_EXC_ERROR;
3116:
3117: END IF;
3118:
3119:
3120: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3121: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
3122: l_msg_string:=FND_MESSAGE.GET;
3123: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3124: -- commented for BUG# 5484686
3125: RAISE FND_API.G_EXC_ERROR;
3126: END IF;
3127:
3130: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3131: -- ,p_data => x_msg_data);
3132: -- commented for BUG# 5484686
3133:
3134: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');
3135:
3136: EXCEPTION
3137: WHEN fnd_api.g_exc_error THEN
3138: ROLLBACK TO EAM_Activity_PUB;