44: FROM mtl_parameters
45: WHERE organization_id = p_organization_id;
46: EXCEPTION
47: WHEN NO_DATA_FOUND THEN
48: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
49: -- FND_MESSAGE.SET_ENCODED('Organization Id invalid.');
50: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
51: RAISE FND_API.G_EXC_ERROR;
52: END;
45: WHERE organization_id = p_organization_id;
46: EXCEPTION
47: WHEN NO_DATA_FOUND THEN
48: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
49: -- FND_MESSAGE.SET_ENCODED('Organization Id invalid.');
50: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
51: RAISE FND_API.G_EXC_ERROR;
52: END;
53:
58: FROM mtl_parameters
59: WHERE organization_code = p_organization_code;
60: EXCEPTION
61: WHEN NO_DATA_FOUND THEN
62: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_CODE');
63: -- FND_MESSAGE.SET_ENCODED('Organization Code invalid.');
64: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
65: RAISE FND_API.G_EXC_ERROR;
66: END;
59: WHERE organization_code = p_organization_code;
60: EXCEPTION
61: WHEN NO_DATA_FOUND THEN
62: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_CODE');
63: -- FND_MESSAGE.SET_ENCODED('Organization Code invalid.');
64: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
65: RAISE FND_API.G_EXC_ERROR;
66: END;
67: ELSE
65: RAISE FND_API.G_EXC_ERROR;
66: END;
67: ELSE
68: -- Error: both organization id and code are NULL
69: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ORG_ID_CODE_NULL');
70: -- FND_MESSAGE.SET_ENCODED('Organization id and organization code cannot be both NULL.');
71: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
66: END;
67: ELSE
68: -- Error: both organization id and code are NULL
69: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ORG_ID_CODE_NULL');
70: -- FND_MESSAGE.SET_ENCODED('Organization id and organization code cannot be both NULL.');
71: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
74:
148: FROM wip_entities
149: WHERE wip_entity_id = p_work_order_rec.wip_entity_id;
150: EXCEPTION
151: WHEN OTHERS THEN
152: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_WIP_ENTITY_ID');
153: -- FND_MESSAGE.SET_ENCODED('Wip Entity Id invalid.');
154: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
155: RAISE FND_API.G_EXC_ERROR;
156: END;
149: WHERE wip_entity_id = p_work_order_rec.wip_entity_id;
150: EXCEPTION
151: WHEN OTHERS THEN
152: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_WIP_ENTITY_ID');
153: -- FND_MESSAGE.SET_ENCODED('Wip Entity Id invalid.');
154: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
155: RAISE FND_API.G_EXC_ERROR;
156: END;
157:
196: WHERE organization_id = l_x_work_order_rec.organization_id
197: AND wip_entity_name = l_x_work_order_rec.wip_entity_name;
198: EXCEPTION
199: WHEN OTHERS THEN
200: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_WIP_ENT_NAME');
201: -- FND_MESSAGE.SET_ENCODED('Wip Entity Name invalid.');
202: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
203: RAISE FND_API.G_EXC_ERROR;
204: END;
197: AND wip_entity_name = l_x_work_order_rec.wip_entity_name;
198: EXCEPTION
199: WHEN OTHERS THEN
200: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_WIP_ENT_NAME');
201: -- FND_MESSAGE.SET_ENCODED('Wip Entity Name invalid.');
202: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
203: RAISE FND_API.G_EXC_ERROR;
204: END;
205:
204: END;
205:
206: ELSE
207: -- Error: both wip entity id and code are NULL
208: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_WIP_ENT_ID_NAME_NULL');
209: -- FND_MESSAGE.SET_ENCODED('Wip Entity Id and Name cannot be both NULL.');
210: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
205:
206: ELSE
207: -- Error: both wip entity id and code are NULL
208: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_WIP_ENT_ID_NAME_NULL');
209: -- FND_MESSAGE.SET_ENCODED('Wip Entity Id and Name cannot be both NULL.');
210: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
278:
279: EXCEPTION
280:
281: WHEN NO_DATA_FOUND THEN
282: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_NO_ITEM_NAME');
283: -- FND_MESSAGE.SET_ENCODED('Cannot find concatenated segment Item name.');
284: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
285:
286: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
279: EXCEPTION
280:
281: WHEN NO_DATA_FOUND THEN
282: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_NO_ITEM_NAME');
283: -- FND_MESSAGE.SET_ENCODED('Cannot find concatenated segment Item name.');
284: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
285:
286: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
287: 'EAM_ActivityUtilities_PVT.Get_Item_Concatenated_Segments: error.' ||
714: WHERE instance_number = p_instance_number;
715: EXCEPTION
716: WHEN OTHERS THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_INSTANCE_NUMBER');
719: -- FND_MESSAGE.SET_ENCODED('Instance number is invalid.');
720: l_x_error_mesg := FND_MESSAGE.GET;
721:
722: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
715: EXCEPTION
716: WHEN OTHERS THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_INSTANCE_NUMBER');
719: -- FND_MESSAGE.SET_ENCODED('Instance number is invalid.');
720: l_x_error_mesg := FND_MESSAGE.GET;
721:
722: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
723: l_x_error_mesg ||
716: WHEN OTHERS THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_INSTANCE_NUMBER');
719: -- FND_MESSAGE.SET_ENCODED('Instance number is invalid.');
720: l_x_error_mesg := FND_MESSAGE.GET;
721:
722: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
723: l_x_error_mesg ||
724: 'p_instance_number=' || p_instance_number);
736: l_x_org_id,
737: l_x_org_code);
738: IF l_x_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
741: l_x_error_mesg := FND_MESSAGE.GET;
742:
743: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
744: l_x_error_mesg ||
737: l_x_org_code);
738: IF l_x_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
741: l_x_error_mesg := FND_MESSAGE.GET;
742:
743: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
744: l_x_error_mesg ||
745: 'p_instance_number=' || p_instance_number ||
764: AND serial_number = p_serial_number;
765: EXCEPTION
766: WHEN OTHERS THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ASSET_GRP_NUM');
769: -- FND_MESSAGE.SET_ENCODED('Asset Group, Number invalid.');
770: l_x_error_mesg := FND_MESSAGE.GET;
771:
772: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
765: EXCEPTION
766: WHEN OTHERS THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ASSET_GRP_NUM');
769: -- FND_MESSAGE.SET_ENCODED('Asset Group, Number invalid.');
770: l_x_error_mesg := FND_MESSAGE.GET;
771:
772: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
773: l_x_error_mesg ||
766: WHEN OTHERS THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ASSET_GRP_NUM');
769: -- FND_MESSAGE.SET_ENCODED('Asset Group, Number invalid.');
770: l_x_error_mesg := FND_MESSAGE.GET;
771:
772: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
773: l_x_error_mesg ||
774: 'p_instance_number=' || p_instance_number ||
796: x_maintenance_object_id := p_inventory_item_id;
797: x_maintenance_object_type := 2;
798: ELSE
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_INV_ITEM_ID');
801: -- FND_MESSAGE.SET_ENCODED('Invalid Inventory Item Id.');
802: l_x_error_mesg := FND_MESSAGE.GET;
803:
804: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
797: x_maintenance_object_type := 2;
798: ELSE
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_INV_ITEM_ID');
801: -- FND_MESSAGE.SET_ENCODED('Invalid Inventory Item Id.');
802: l_x_error_mesg := FND_MESSAGE.GET;
803:
804: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
805: l_x_error_mesg ||
798: ELSE
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_INV_ITEM_ID');
801: -- FND_MESSAGE.SET_ENCODED('Invalid Inventory Item Id.');
802: l_x_error_mesg := FND_MESSAGE.GET;
803:
804: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
805: l_x_error_mesg ||
806: 'p_instance_number=' || p_instance_number ||
1284:
1285: Is_Debug := g_NO;
1286:
1287: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1288: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CANNOT_CREATE_LOG_FILE');
1289: -- FND_MESSAGE.SET_ENCODED('Cannot create log file.');
1290: FND_MSG_PUB.ADD;
1291: END IF;
1292: END;
1285: Is_Debug := g_NO;
1286:
1287: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1288: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CANNOT_CREATE_LOG_FILE');
1289: -- FND_MESSAGE.SET_ENCODED('Cannot create log file.');
1290: FND_MSG_PUB.ADD;
1291: END IF;
1292: END;
1293:
1310: WHEN OTHERS THEN
1311: Is_Debug := g_NO;
1312:
1313: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1314: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ERROR_WRITING_TO_LOG');
1315: -- FND_MESSAGE.SET_ENCODED('Error writing to log file.');
1316: FND_MSG_PUB.ADD;
1317: END IF;
1318: END Write_Debug;
1311: Is_Debug := g_NO;
1312:
1313: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1314: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ERROR_WRITING_TO_LOG');
1315: -- FND_MESSAGE.SET_ENCODED('Error writing to log file.');
1316: FND_MSG_PUB.ADD;
1317: END IF;
1318: END Write_Debug;
1319:
1347: BEGIN
1348: if(l_ulog) then
1349: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
1350: end if;
1351: -- add message to fnd message stack
1352: IF FND_MSG_PUB.Check_Msg_Level(p_message_level)
1353: THEN
1354: -- Push message onto fnd message stack
1355: FND_MSG_PUB.ADD;
1350: end if;
1351: -- add message to fnd message stack
1352: IF FND_MSG_PUB.Check_Msg_Level(p_message_level)
1353: THEN
1354: -- Push message onto fnd message stack
1355: FND_MSG_PUB.ADD;
1356: -- Get translated message
1357: l_message_text := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
1358: ELSE
1355: FND_MSG_PUB.ADD;
1356: -- Get translated message
1357: l_message_text := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
1358: ELSE
1359: -- Message not pushed onto fnd message stack
1360: l_message_text := FND_MESSAGE.GET;
1361: END IF;
1362:
1363: -- Also output message to log file
1356: -- Get translated message
1357: l_message_text := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
1358: ELSE
1359: -- Message not pushed onto fnd message stack
1360: l_message_text := FND_MESSAGE.GET;
1361: END IF;
1362:
1363: -- Also output message to log file
1364: if (l_plog) then